Multiple If Statements

[baker_89]

=IF(G3<>"",F3+G3,IF(H3<>"",F3+H3,"0"))
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Hello, I am trying to set up a formula that depending on where information is plugged in will add certain cells. Otherwise if they are blank leave it at "0". Also trying to add in if BOTH have numbers add certain cells (F3+G3).

I am currently getting a circular reference.

 

[Michael M]

if you are getting a circular reference....you're probably putting the formula in one of the cells IN the formula....ie, f3, g3 or h3

 

[baker_89]

You are correct! Cannot believe I missed that, Thanks!

 

[Michael M]

easy trap for young players....