Novice user trying to use variables including text and numbers
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
|