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

On Dec 2, 3:41*pm, Betty K wrote:
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.

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.
--
Max
Singapore
xde
---
"Betty K" wrote:
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.

Thank you!

"Max" wrote:

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.
--
Max
Singapore
xde
---
"Betty K" wrote:
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.

Welcome, Betty
--
Max
Singapore
xde
"Betty K" wrote in message
...
Thank you!