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","")
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","")
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",""))
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",""))
=IFAND((D218<>0,D218<3,"Min 3 Required","")