hi, Rachel !

not sure i'm following you correctly (but) you might want to give a try...

=--if(d7<"na",and(d7=2,f7<100))

hth,
hector.

__ OP __
I'm completely self taught so hope this is possible
I've tried a number of formula but the nearest is
=IF(($D$7<2)*($F$7100)*($D$7="NA"),0,1)
what i need to do is assign a value of 1 or 0 when adding different arguments
I need a result of 0 if D1 is under 2.00 F1 is over 100 or the result in the D coloum reads NA
can't change NA to read something else as its imported from another source.
I also need a result of 1 if D1 is 2.00 or over, if F1 is under 100
everyway i try to do this counts NA as being larger than 2.00
Any help gratefully received, thanks