Hi, I am struggling to get the following IF statement to work:-
=IF(C4375<1216,"00:22", IF(C4375>1216,"00:30", IF(C4375<500,"0")))
Where the element in column C is an imported value from a PI add in and the possible output values are to be minutes, either 30,22 or 0.
Writing the formula with 2 outcomes works fine, but I can't get it to function with 3.
Also tried to write the output as "30", "22" and "0" as the summation of a daily column doesn't seem to work.
Any suggestions welcome
Thanks
Swap the formula around as below
Show your appreciation - Press the star icon if this post has been helpful
Please Login or Register to view this content.
Hi and welcome to the forum.
Try
=IF(and(C4375<1216,c4375>500),"00:22", IF(C4375>1216,"00:30", IF(C4375<500,0)))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
That's worked a treat. ThanksOriginally Posted by Ace_XL
Swap the formula around as below
Show your appreciation - Press the star icon if this post has been helpfulPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks