IF statements

[decini]

I am new to excel, however i really need this code. Here what I need t
do.

=IF(f60<=25,10,0,IF(f60=>26,20,0),IF (f60=>46,25,0),IF (f60=>71,30,0))


If an number in any given cell is greater than or equal to 10 but les
that 25 then mutiply that cell by 10, but if the cell data is equal t
or greater than 26 but less than 45 or equal to 45 then multiply tha
cell be by 20, but if the cell data is equal to or greater than 46 bu
less than 70 or equal to 45 then multiply that cell be by 25, but i
the cell data is equal to or greater than 70 or more then multiply tha
cell be by 30. It wont work for me I spent 5 hours trying to get it bu
still cant.

Any help would be GREATLY appriciated


-decin

 

[JulieD]

Hi

you're just about there

=IF(F60>=10,IF(F60>=26,IF(F60>=46,IF(F60>=70,F60*30,F60*25),F60*20),F60*10),
0)

Cheers
JulieD

 

[Don]

Try:

=IF(A1<10,"",IF(AND(A1>=10,A1<25),A1*10,IF(AND
(A1>=25,A1<=45),A1*20,IF(AND(A1>45,A1<=70),A1*25,IF
(A1>=70,A1*30)))))

Not tested for all occurences but I think it'll do what
you want....

HTH,

Don

 

[decini]

Thanks a bunch it work great.






-Decin

 

[Jack Schitt]

An alternative:

=F60*((F60>70)*5+(F60>45)*5+(F60>25)*10+(F60>9)*10)

 

[decini]

Thanks to all who helped.



-Decini :cool