If Then Help

[mbishop2008]

Writing an if / then statement where I need 0 to display "0". I need 1 to display a certain field (F3) ,2 to display a certain field (F4) and 0 to display zero.

I had this formula and it works for 1 and 2, but 0 is coming back as the same as 1 because, well its less than 1. =IF(B6>2,$F$4)+IF(B6<2,F$3,F$4)

 

[Georgiboy]

Maybe:

=IF(B6=0,0,IF(B6=1,$F$3,IF(B6=2,$F$4,"")))