Conditional formulas

  • Thread starter Thread starter Betty K
  • Start date Start date
B

Betty K

Need a formula based on a Status.

If Status is "A", it needs to calculate (T2*5)+35

If Status is "L", it needs to return 0 (zero)

If Status is "H", it needs to return 35

If Status is "P", it needs to return "NA"

Thank you in advance.
 
Try this:

=IF(cell="L",0,IF(cell="H",35,IF(cell="A",T2*5+32,"NA")))

where cell is your Status. This will trap any other entries and return
"NA", in addition to Status = "P".

Hope this helps.

Pete
 
Assuming the various statuses (A, L, H, P) are running in S2 down
you could try this placed in say, U2:
=IF(S2="","",IF(S2="A",(T2*5)+35,VLOOKUP(S2,{"L",0;"H",35;"P","NA"},2,0)))
Copy U2 down as far as required. Modify to suit. Any good? hit the YES below.
 
Thank you!

Max said:
Assuming the various statuses (A, L, H, P) are running in S2 down
you could try this placed in say, U2:
=IF(S2="","",IF(S2="A",(T2*5)+35,VLOOKUP(S2,{"L",0;"H",35;"P","NA"},2,0)))
Copy U2 down as far as required. Modify to suit. Any good? hit the YES below.
Click to expand...
 
Back
Top