equals the actual number...not text ????

G

Guest

I have a formula in e2 that goes like this:
=IF(d2>50,"50",IF(d2>25,"25",IF(d2<26,a2)))

d2=b2*c2
a2 would be a number between 1 and 150

then i want to put the greater of a2 and e2 into f2
and writing like this =max(a2,e2)

it won't select the value in e2, it always elects value in a2

how can i fix ?
 
G

Guest

I think that if you look at your IF function and remove the double inverted
commas from the numbers ie. =IF(d2>50,50,IF(d2>25,25,IF(d2<26,a2))), then it
should work.
 
B

Biff

Hi!

Try removing the quotes from around your numbers:

=IF(d2>50,50,IF(d2>25,25,IF(d2<26,a2)))

Biff
 
G

George

Remove the quotes from the 50 and 25, you are entering them as text not
as number
Also you can lose the last if statement
=IF(d2>50,50,IF(d2>25,25,a2)))

George
 
G

Guest

thanks

George said:
Remove the quotes from the 50 and 25, you are entering them as text not
as number
Also you can lose the last if statement
=IF(d2>50,50,IF(d2>25,25,a2)))

George
Click to expand...
 
G

Guest

thanks

MarkN said:
I think that if you look at your IF function and remove the double inverted
commas from the numbers ie. =IF(d2>50,50,IF(d2>25,25,IF(d2<26,a2))), then it
should work.
Click to expand...
 

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

Copying formulas across columns 2
More Planned and Actual Cycle Times 5
Conditional sum, when condition has multiple values 3
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula 2
Payment calculation 1
Formula Problem For Checkbook Register 1
Logical if more than 7 4
HELP with crazy formula 9

Top