IF Statement

[Redlittle]

I have a basic sum formula for example SUM(F7:G7) in cell H7, however if there are no figures in either F or G, I want H to remain a blank cell as supposed to returning "0"

How can I go about this?

Thanks in advance

[PaulM100]

Try: =if(or(f7="",g7=""),"",SUM(F7:G7)

[Redlittle]

Sorry maybe I did not explain myself 100%

Your formula works but it only works if there are numbers in both F & G, I need H to return the sum if only one of the cells F or G contain a number.

Thanks in advance

[AliGW]

Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
  
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

Change the thread title now, please. Thanks.

[Redlittle]

Thanks for your help, spot on

[AliGW]

Redlittle - please note post #4.