Any Excel experts?

[lizziegrace]

I need help with a formula.

[Catshrink]

1. OK...

I'll give it a try. What are you trying to do?

[lizziegrace]

2. Salary spreadsheet

I need to look at every cell in a column and those that have values exceeding $1056 need to be replaced with $1056 (salary cap for Workers' Comp reporting.)

[edwin]

3. Here ya go:

If the cell you're looking at is A1, then the formula is =IF(A1<=1056,A1,1056)

Can I be the lounge nerd now?

[lizziegrace]

6. You're in the running!

:hi:

[Orrex]

12. A minor correction, I think

If the cell you're looking at is A1, then the formula is =IF(A1<=1056,A1,1056)

Shouldn't that be

=IF((A1<=1056),A1,1056)

with two sets of parentheses?

[edwin]

13. You can, but don't have to. n/t

[Orrex]

14. Maybe I'm thinking of Access. Or Pac-Man (nt)

[Catshrink]

4. You need an If statement

=If(cell>1056, 1056)

That should do it... I'm going to try it out.

[lizziegrace]

5. Stupid question

how do I apply this?

[LynzM]

8. Insert a column to the right of the column you want to change

copy =if(cell to the left>1056, 1056, cell to the left)

Where I wrote "cell to the left", you want to write, for example, A3.

Paste that into the blank cells that are to the right of the column. You can paste into the first cell and then either click and drag down, or copy and paste to fill the rest of the column.

After that, if it works correctly and you want to keep it, highlight the whole column, copy, "paste special" - choose values. Now you can delete your original column without messing up the column that you pasted the formula into.

Yeah, I wanna be the Lounge Geek too, please! :bounce:

[lizziegrace]

9. Thanks!

You're an official geek. :)

I ended up doing it manually because I had no idea what to do with it. I've been doing payroll returns for days now and I just wanted to get this one finished.

:hug:

[LynzM]

10. LOL

Sorry 'bout that, a little late to the party. Ah well, now you know for next time!

[pokerfan]

11. This website has a good explanation

http://www.personal-computer-tutor.com/if1.htm

You definitely want to add the IF expression to your bag of tricks. You will be so much more productive.

[edwin]

7. Only works if cell is greater than 1056

:hi: from a fellow AZ-er.