View Full Version : [SOLVED:] Add another condition to formula
Barryj
04-03-2006, 05:13 PM
I have this formula that show Min 3 required when the target cell number is less than 3, I cannot alter it to show if the target cell D218=0 then also show nothing.
=IF(D218<3,"Min 3 Required",""):banghead:
geekgirlau
04-03-2006, 05:23 PM
It should already cope with that situation, as 0 is less than 3.
If you also want to check for "" in D218,
=IF(D218="","",IF(D218<3,"Min 3 Required",""))
Barryj
04-03-2006, 05:28 PM
Thanks for that geekgirl, I just had to change the ="" to =0 and works great, thanks again.
=IF(D218=0,"",IF(D218<3,"Min 3 Required",""))
Bob Phillips
04-04-2006, 01:51 AM
=IFAND((D218<>0,D218<3,"Min 3 Required","")
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.