I need help with an excel formula, can I please get help
 

The question Is, I trying to put in a formula for two things at the same
time, the first scenario is if a salary is $36,501, I need it to show to the
next nearest thousand, and also if the salary is over 50, 000, for exampleit
is $86,500, I need it to default to 50,000. Please help.


36,501 = 37,000
and 86,500 = 50,000
Tanzeer

Hi

=IF(A1=36501,Round(A1,-3),IF(A150000,50000,A1))

this says if A1 (your salary) is 36501, round it to the nearest thousand
(you could substitute 37000 where i've got Round(A1,-3) ) or if A1 is
greater than 50000 make it 50000.

if the salary is anything else other than 36501 or "over 50000" then just
return that value.

I hope that this is what you're after.

Cheers
JulieD



"Tanzeer" wrote in message
...
The question Is, I trying to put in a formula for two things at the same
time, the first scenario is if a salary is $36,501, I need it to show to
the
next nearest thousand, and also if the salary is over 50, 000, for
exampleit
is $86,500, I need it to default to 50,000. Please help.


36,501 = 37,000
and 86,500 = 50,000
Tanzeer

Maybe

=IF(A1=50000,50000,ROUND(A1,-3))


Regards,

Peo Sjoblom

"Tanzeer" wrote:

The question Is, I trying to put in a formula for two things at the same
time, the first scenario is if a salary is $36,501, I need it to show to the
next nearest thousand, and also if the salary is over 50, 000, for exampleit
is $86,500, I need it to default to 50,000. Please help.


36,501 = 37,000
and 86,500 = 50,000
Tanzeer