Add another condition to formula

[Barryj]

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]

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]

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]

=IFAND((D218<>0,D218<3,"Min 3 Required","")