Hi,
I am usually pretty good on this but I am stumped by this.
I need an if statement which says
If(AB2>0,AB2,Z2,False)
But I need to build in that if Z2 =N/A AND ab2 is blank then return X2 to the last bit.
Thanks for any help.
Hi,
I am usually pretty good on this but I am stumped by this.
I need an if statement which says
If(AB2>0,AB2,Z2,False)
But I need to build in that if Z2 =N/A AND ab2 is blank then return X2 to the last bit.
Thanks for any help.
Last edited by timbo1957; 11-12-2013 at 07:27 AM.
Formula:Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
=if(ab2>0,ab2,if(isna(z2),x2,z2))
You edited your requirement after I posted your solution.
Now try:
Formula:Please Login or Register to view this content.
Hi
Check this formula
=IF(AB2>0,AB2,IF(AND(ISNA(Z2)=TRUE,AB2=""),X2,Z2))
All solutions work
Many thanks to all.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks