View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Betty K Betty K is offline
external usenet poster
 
Posts: 8
Default Conditional formulas

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.