Multiple IF/OR stmts in a function

  • Thread starter Thread starter Smilinjayd
  • Start date Start date
S

Smilinjayd

I need to create function consisting of three "IF" stmts. The formula
would need to be something like: IF "N2"="h" then multiply ("M2"*"I2")
* 52. OR, IF "N2"="W" then multiply "M2"*52. OR, IF "N2" = "m", then
multiply "M2" * 12. Can someone help me write this string? Thanks in
advance.
 
=IF(N2="h",M2*I2, IF(N2="W", M2*52, IF(N2="m", M2*12, "None of the above")))

Some thing to note:
1)You can have a maximum of 7 nested IFs
2)Cell references like N2 must not be in quotes
3) Excel is not case sensitive, the value of w or W in N2 will give the same
result
4)The correct name for what I have given you is a 'formula' not a 'string'.
In Excel a string is a series of alphanumeric characters such as "The cow
jumped over the moon"

Best wishes
Bernard
 
Back
Top