I am a novice with excel so I really hope this makes sense to those of you who are experts.

The following code is placed in box I3

#=IF H3 ><0.00 then =SUM(L2)-(H3)#

(if H3 is any interger negative or positive then perform calculation)

(If H3 false then I3 "remains blank" with no words or numbers in it)

Excel has been telling me this wont work.

I will start from the begining:

Box L2 has a sum from another worksheet in it.

I want to have box I3 display the sum of boxes L2 and H3.

I only want it to display the result if there is an interger put into box H3.

If there is nothing put into box H3, I would like I3 do remain blank.

________________________________________________________

In other words:

I4 should only display the sum of I3 and H4 if and only if a value has been typed into H4.

or

I5 should only display the sum of I4 and H5 if and only if a value has been typed into H4

Subsequently:

I would like box L3 to choose the value of the last box in column I with a SUM in it to display, even if that value is $0.00 But that wont work correctly if 0.00 or any other number goes on to infinity.

Further:

I3 = $6.00

H4 = $-5.00

I4 = $1.00

H5 = Blank

I5 = Blank (because an interger has not been typed into H5)

L3 = $1.00 (by choosing I4 because I5 was blank)

Specifically the problem I am having is, if I #=SUM(L2)+(H3) and copy that code to all the boxes in column I then I get the sum of the last calculation to infinity. Or I can make the values $0.00 to infinity but then L3 will not choose correctly.

Any help with this would be great! I have been messing with =If and =SUMIF as well as a few other trials and I cant get anything to work.

## Bookmarks