Democratic Underground Latest Greatest Lobby Journals Search Options Help Login
Google

Any Excel experts?

Printer-friendly format Printer-friendly format
Printer-friendly format Email this thread to a friend
Printer-friendly format Bookmark this thread		 This topic is archived.
Home » Discuss » The DU Lounge Donate to DU
 
lizziegrace Donating Member (1000+ posts) Send PM | Profile | Ignore Mon Jan-29-07 08:08 PM
Original message
Any Excel experts?
I need help with a formula.
Printer Friendly | Permalink |  | Top
Catshrink Donating Member (1000+ posts) Send PM | Profile | Ignore Mon Jan-29-07 08:11 PM
Response to Original message
1. OK...
I'll give it a try. What are you trying to do?
Printer Friendly | Permalink |  | Top
 
lizziegrace Donating Member (1000+ posts) Send PM | Profile | Ignore Mon Jan-29-07 08:12 PM
Response to Reply #1
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.)
Printer Friendly | Permalink |  | Top
 
edwin Donating Member (263 posts) Send PM | Profile | Ignore Mon Jan-29-07 08:15 PM
Response to Reply #2
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?
Printer Friendly | Permalink |  | Top
 
lizziegrace Donating Member (1000+ posts) Send PM | Profile | Ignore Mon Jan-29-07 08:16 PM
Response to Reply #3
6. You're in the running!
:hi:
Printer Friendly | Permalink |  | Top
 
Orrex Donating Member (1000+ posts) Send PM | Profile | Ignore Mon Jan-29-07 11:53 PM
Response to Reply #3
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?
Printer Friendly | Permalink |  | Top
 
edwin Donating Member (263 posts) Send PM | Profile | Ignore Tue Jan-30-07 12:22 AM
Response to Reply #12
13. You can, but don't have to. n/t
Printer Friendly | Permalink |  | Top
 
Orrex Donating Member (1000+ posts) Send PM | Profile | Ignore Tue Jan-30-07 12:32 AM
Response to Reply #13
14. Maybe I'm thinking of Access. Or Pac-Man (nt)
Printer Friendly | Permalink |  | Top
 
Catshrink Donating Member (1000+ posts) Send PM | Profile | Ignore Mon Jan-29-07 08:15 PM
Response to Reply #2
4. You need an If statement
=If(cell>1056, 1056)

That should do it... I'm going to try it out.
Printer Friendly | Permalink |  | Top
 
lizziegrace Donating Member (1000+ posts) Send PM | Profile | Ignore Mon Jan-29-07 08:16 PM
Response to Reply #4
5. Stupid question
how do I apply this?
Printer Friendly | Permalink |  | Top
 
LynzM Donating Member (1000+ posts) Send PM | Profile | Ignore Mon Jan-29-07 09:51 PM
Response to Reply #5
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:
Printer Friendly | Permalink |  | Top
 
lizziegrace Donating Member (1000+ posts) Send PM | Profile | Ignore Mon Jan-29-07 09:53 PM
Response to Reply #8
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:
Printer Friendly | Permalink |  | Top
 
LynzM Donating Member (1000+ posts) Send PM | Profile | Ignore Mon Jan-29-07 09:54 PM
Response to Reply #9
10. LOL
Sorry 'bout that, a little late to the party. Ah well, now you know for next time!
Printer Friendly | Permalink |  | Top
 
pokerfan Donating Member (1000+ posts) Send PM | Profile | Ignore Mon Jan-29-07 10:24 PM
Response to Reply #9
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.
Printer Friendly | Permalink |  | Top
 
edwin Donating Member (263 posts) Send PM | Profile | Ignore Mon Jan-29-07 08:19 PM
Response to Reply #4
7. Only works if cell is greater than 1056
:hi: from a fellow AZ-er.
Printer Friendly | Permalink |  | Top
 
DU AdBot (1000+ posts) Click to send private message to this author Click to view this author's profile Click to add this author to your buddy list Click to add this author to your Ignore list Fri May 03rd 2024, 04:32 AM
Response to Original message
Advertisements [?]
 Top

Home » Discuss » The DU Lounge Donate to DU

Powered by DCForum+ Version 1.1 Copyright 1997-2002 DCScripts.com
Software has been extensively modified by the DU administrators

Important Notices: By participating on this discussion board, visitors agree to abide by the rules outlined on our Rules page. Messages posted on the Democratic Underground Discussion Forums are the opinions of the individuals who post them, and do not necessarily represent the opinions of Democratic Underground, LLC.

Home  |  Discussion Forums  |  Journals |  Store  |  Donate

About DU  |  Contact Us  |  Privacy Policy

Got a message for Democratic Underground? Click here to send us a message.

© 2001 - 2011 Democratic Underground, LLC