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