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