R
Rachel Tulloch
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$7>100)*($D$7="NA"),0,1)
what i need to do is assign a value of 1 or 0 when adding differen
arguments
I need a result of 0 if D1 is under 2.00 F1 is over 100 or the resul
in the D coloum reads NA, can't change NA to read something else as it
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, thank
I've tried a number of formula but the nearest is
=IF(($D$7<2)*($F$7>100)*($D$7="NA"),0,1)
what i need to do is assign a value of 1 or 0 when adding differen
arguments
I need a result of 0 if D1 is under 2.00 F1 is over 100 or the resul
in the D coloum reads NA, can't change NA to read something else as it
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, thank