Multiple IF/OR stmts in a function

[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.

 

[Peo Sjoblom]

=IF(N2="h",M2*I2*52,IF(N2="W",M2*52,IF(N2="m",M2*12,"nothing")))

 

[Bernard V Liengme]

=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

 

[may]

=IF(N2="h",(M2*I2)*52,IF(N2="W",M2*52,IF(N2="m",M2*12,"No
match")))