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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top