View Single Post
  #1   Report Post  
Rachel Tulloch Rachel Tulloch is offline
Junior Member
 
Posts: 2
Default 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