Tech Support Guy banner

Excel Mulitple Formula Help

743 Views 1 Reply 2 Participants Last post by  etaf
I am trying to add several cells together, and if the result returns a positive number add that number to another cell.

H8+H12 go into H21

But if H20 is positive I wanted to add that into the total of H21 as well.

I think it will two formulas, but I am not sure how to do it.

=IFFUNCTION or is it =COUNTIF

Any help would be greatly appreciated!
Status
Not open for further replies.
1 - 2 of 2 Posts
=if( H20 > = 0 , H8+H12+H20 , H8+H12 )
1 - 2 of 2 Posts
Status
Not open for further replies.
Top