Hi,
I am looking for a formula to understand if an item has a first time demand.
Basically, I have 12 months and either numbers or zeros in each
Therefore, if I was looking to see if there is first time demand for December I think the formula should be something like:
If A12 = "x" number and A1 - A11 = "0" then show "x" number or 0
I hope that someone can understand...
Last edited by Clint; 05-21-2012 at 09:02 AM.
If I understood correctly, then your formula should read like this:
=IF(And(A12=x,A1-A12=0),x,0) where you would substitute some number for x.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thanks, in the end I needed the following
=If(and(or(J2>1;J2=1);Sum(K2:U2)=0);"First time"; "not first")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks