I'm looking for an IF formula that does the following:
If cell 014 is less than or equal to 0 than = 2, if cell O14 is between 1 and 300 than = 1, if cell 014 is greater than 300 than = 0.
Not really good with these IF formulas yet.
I'm looking for an IF formula that does the following:
If cell 014 is less than or equal to 0 than = 2, if cell O14 is between 1 and 300 than = 1, if cell 014 is greater than 300 than = 0.
Not really good with these IF formulas yet.
Last edited by adamheon; 11-08-2013 at 10:14 AM.
If O14 can be a fraction:
=IF(O14<=0, 2, IF(AND(O14>=1, O14<=300), 1, IF(O14>300, 0, "")
If O14 is a whole number
=IF(O14<=0, 2, IF(O14<=300, 1, 0)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
=if(o14<=0,2,if(o14>300,0,1))
Try
=(O14<=0)+(O14<=300)
A slightly different approach:
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...
Great thanks!
I just realized i actually need to to be:
if O14 is between 0 and -300 than = 2, if greater than 1 = 1, if less than -300 = 0
=if(O14>1,1,if(<-300,0,2))
great that worked perfect.
Just had to had 014 after the (
=IF(O14>1,1,IF(O14<-300,0,2))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks