using IF to select 2 different formulas

[mrbowtieguy]

I'm trying to use the IF to select 2 different formulas depending on
the text entered.
here is what I got so far ,
=IF(J20="r",G20/3800,IF(J20="s",G20\15000))

It functions correct when you input a "r", but gives me the #NAME?
error when a "s" is entered.

Can anyone offer a solution to this problem?

Morris

 

[Dan E]

Morris,

=IF(J20="r",G20/3800,IF(J20="s",G20/15000))

You used a \ instead of a /

Dan E