Slap_Shot
04-06-2005, 04:18 PM
Since there's no forum for complete Excel idiots, I'm posting this here. :doh:
I've got a formula that needs to take the first cell, then subtract the 3 cells below it (all these cells, by the way, are called from other workbooks). Here's what I'm using:
=IF(SUM(B4,-B5,-B6,-B7)=0,"",SUM(B4,-B5,-B6,-B7))
Now the trick is that sometimes one of the b5-b7 cells is empty. I thought setting up the formula this way was is supposed to stop the rotten, evil little #VALUE! thing (:devil:) , but its not working. The formula works when there's values in all the cells, but shows the rotten, evil #VALUE! when one cell is empty.
Is there a way for the formula to still perform the calculations even if there's one cell that doesn't have a value?
Thanks in advance!!!
I've got a formula that needs to take the first cell, then subtract the 3 cells below it (all these cells, by the way, are called from other workbooks). Here's what I'm using:
=IF(SUM(B4,-B5,-B6,-B7)=0,"",SUM(B4,-B5,-B6,-B7))
Now the trick is that sometimes one of the b5-b7 cells is empty. I thought setting up the formula this way was is supposed to stop the rotten, evil little #VALUE! thing (:devil:) , but its not working. The formula works when there's values in all the cells, but shows the rotten, evil #VALUE! when one cell is empty.
Is there a way for the formula to still perform the calculations even if there's one cell that doesn't have a value?
Thanks in advance!!!