|
Welcome to the YorkieTalk.com Forums Community - the community for Yorkshire Terriers. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. You will be able to chat with over 35,000 YorkieTalk members, read over 2,000,000 posted discussions, and view more than 15,000 Yorkie photos in the YorkieTalk Photo Gallery after you register. We would love to have you as a member! Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please click here to contact us. |
|
| LinkBack | Thread Tools |
11-03-2011, 05:48 AM | #1 |
Donating YT 500 Club Member Join Date: Nov 2008 Location: Where the deer and the antelope play
Posts: 7,069
| Any Excel Spreadsheet experts here? I am having a problem with a formula and I want to fix it. I have two columns, both with a sum figured from a formula. The third column then takes the difference from those two colums. It's a simple formula. Every once in a while when the third column (the difference in the first two) is a 0 I get an error in that column. However, this happens frequently and I have other situations where it will figure the 0 without the error, same exact formulas. Anyone know how to fix it, or what causes this? It's driving me nuts that I can't figure it out. A co worker says she has the same problem with one of her spreadsheets. We both know excel pretty well, but apparently can't figure out the easy stuff. This is the error code I get: 9.09E-13
__________________ Shelly and the girls Moka Mylee |
Welcome Guest! | |
11-03-2011, 06:49 AM | #2 |
Donating YT 2000 Club Member Join Date: May 2008 Location: Los Angeles, California, USA
Posts: 12,693
| Is the entire 3rd column programmed to show you the answer in a specific manner?
__________________ Littlest JakJak We miss you Kaji |
11-03-2011, 07:04 AM | #3 |
Donating YT 500 Club Member Join Date: Nov 2008 Location: Where the deer and the antelope play
Posts: 7,069
| Yes, the third cell is the difference between the two cells previous to that in the row, then the entire column is formulated to add those answers for a total of a given group.
__________________ Shelly and the girls Moka Mylee |
11-03-2011, 07:34 AM | #4 |
Donating YT 2000 Club Member Join Date: May 2008 Location: Los Angeles, California, USA
Posts: 12,693
| I mean how you want the answer to be displayed. Ex. Money can be dispalyed in dollar amounts only, dollars and cents, the amount can turn red if it's a negative amount, etc. Is that specified?
__________________ Littlest JakJak We miss you Kaji |
11-03-2011, 07:41 AM | #5 | |
Donating YT 500 Club Member Join Date: Nov 2008 Location: Where the deer and the antelope play
Posts: 7,069
| Quote:
ETA! There are lots of smart people here at YT. You can find the answers to anything here. You're all awesome!
__________________ Shelly and the girls Moka Mylee Last edited by Cha Cha; 11-03-2011 at 07:42 AM. | |
11-03-2011, 07:44 AM | #6 |
Donating YT 2000 Club Member Join Date: May 2008 Location: Los Angeles, California, USA
Posts: 12,693
| I'm a different s word. SLOW! I had to open my laptop and try different things out!
__________________ Littlest JakJak We miss you Kaji |
11-03-2011, 08:02 AM | #7 | |
Donating YT 500 Club Member Join Date: Nov 2008 Location: Where the deer and the antelope play
Posts: 7,069
| Quote:
lol, talk about slow. This has eluded me for 8 years. I finally gave up and figured it wouldn't hurt to ask. Almost ALWAYS it's one of those slap in the face easy answers. You got it much faster than I.
__________________ Shelly and the girls Moka Mylee | |
11-03-2011, 08:09 AM | #8 |
Donating YT 2000 Club Member Join Date: May 2008 Location: Los Angeles, California, USA
Posts: 12,693
| I've come to the conclusion that computers are temperamental and they don't like me. With a little ingenuity, I can make them do what I want them to do.
__________________ Littlest JakJak We miss you Kaji |
Bookmarks |
|
|
| |
|
|
SHOP NOW: Amazon :: eBay :: Buy.com :: Newegg :: PetStore :: Petco :: PetSmart