LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
jessicawalton
 
Posts: n/a
Default Help with combination formula

Hi Guys:
I'm trying to combine a couple of different functions in one formula and
can't seem to get it to work. First I want a formula that adds a series of
cells, but I also want the cell to blank out if the sum is zero AND I want it
to blank out if there's any type of error (such as div/0 or value/#). Here's
what I have that's working so far:

=IF(SUM(C3+D3+E3+F3)<=0,"",SUM(C3+D3+E3+F3))

and this is giving me the true sum. I also want to do the same with the
following:

=B3-G3
=I3/K3

So, I need two things...how do I add the part to handle errors in the first
formula above and then how do I do both for the second and third formulas.

Let me know. I'm SO glad we have this resource...it's a lifesaver sometimes!

Have a great weekend all!
Jessica
Virginia Beach, VA
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple formula doesn't quite add up circeo Excel Discussion (Misc queries) 3 January 17th 05 09:04 PM
Formula displays does not calculate Neil Bhandar Excel Discussion (Misc queries) 4 January 10th 05 10:55 PM
how do I make a formula NOT change when the data range is moved? Alida Andrews Excel Discussion (Misc queries) 2 January 6th 05 09:02 PM
Creating Formula using check boxes Anthony Slater Excel Discussion (Misc queries) 3 January 4th 05 03:03 PM
What instead of an array formula part 2 Reg Besseling Excel Discussion (Misc queries) 2 December 10th 04 07:35 AM


All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"