Embedded IF Function

[mrskidder]

I am trying to do an IF function where there are 3 possible scenarios.

The first Scenario is if the Pay Frequency is a S then the dollars are multiplied by 2
The second Scenario is if the Pay Frequency is a W then the dollars are multiplied by 52 and divided by 12 (to get a monthly amount)
The final Scenario is if the Pay Frequency is a M then it is just the dollar amount cell.

Here is what I have come up with:

=IF(D2=S,C2*2,IF(D2=W,C2*52/12,IF(D2=M,C2)))

The above function is coming back with a #NAME? error.

Any thoughts?

 

[bbott]

You need to put your text in quotes:

=IF(D2="S",C2*2,IF(D2="W",C2*52/12,IF(D2="M",C2))

You may also want to consider adding a false argument for your last IF statement unless you want it to display FALSE when D2 does not equal any of those options.

 

[mrskidder]

Thank you!! I forgot about putting quotes around text.

 

[bbott]

Thank you!! I forgot about putting quotes around text.

You're welcome.