Formula for calculation based on multiple conditions

[hforman]

Hi, I'm working on a payroll spreadsheet for use in Workers Compensatio
Premium Audits. For the purposes of workers comp, executive officer
have a minimum salary of $10,400, and a maximum of $52,000. So I woul
like to have a column of each officer's actual salary, then thei
adjusted salary in the next column.

Ex.
.....................actual.........adjusted
John Smith....$8,000.......$10,400
Sue Quinn.....$60,000.....$52,000
Jack Black.....$27,500.....$27,500

Is there any way to write a formula that says if a cell value is les
than a certain value, it equals one thing... if it's more than
certain value, it equals another thing... and if it is in between thos
values, it is as entered.

thank you

 

[Guest]

Assuming your salaries are in column b
=IF(b1<10400,10400,IF(b1>52000,52000,b1))

 

[Frank Kabel]

Hi
in C2 use
=MAX(MIN(B2,52000),10400)