Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
Formula displays does not calculate | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Creating Formula using check boxes | Excel Discussion (Misc queries) | |||
What instead of an array formula part 2 | Excel Discussion (Misc queries) |