Thread: 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(A1>50000,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" <Tanzeer@discussions.microsoft.com> wrote in message
news:A477041D-979B-48EB-8167-E78DF9404964@microsoft.com...
> 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
>