Help with IF statements

[barcop]

Hi all,

This is my first post.

How do I go about creating a formula that will do all of these in one?

=IF(V3>0,"Dirty","Clean")
=IF(LEFT(BT3,3)="Ops","Dirty",IF(LEFT(BT3,3)="Non","Clean"))
=if(BT3="","")

Your help would be very much appreciated.

Regards

barcop

 

[Robert Mika]

Try this:
=IF(BT3="","",IF(LEFT(BT3,3)="Ops","Dirty",IF(LEFT(BT3,3)="Non","Clean",IF(V3>0,"Dirty","Clean"))))