using IF to select 2 different formulas

  • Thread starter Thread starter mrbowtieguy
  • Start date Start date
M

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:(
 
Morris,

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

You used a \ instead of a /

Dan E
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula is to long 8
Modifying a Formula 4
Date in "If" formula 5
more than 7 nested IF(AND) statements in formula - VBA? **NEWBIE** 3
variable number formats 2
using 2 different IF statements 2
Copy formula help 2
Row reference in a formulas 3

Back
Top