Share via

EXCEL IF FUNCTION

Anonymous
2018-01-17T06:58:38+00:00

I NEED A HELP ON HOW TO USE AN IF FORMULA IN MY SUM FUNCTION.

THE PROBLEM IS THAT I WANT TO ADD C7 AND D7 WITH THE RESULT IN E7, IF C7 AND D7 ARE EMPTY, I WANT E7 TO BE EMPTY, IF THEY HAVE 0(ZERO), I WANT 0(ZERO) RETURNED, OTHERWISE, I WANT THE RESULT IN E7.

PLEASE HELP

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-01-18T08:14:32+00:00

    HansV MPV

    THANKS VERY MUCH FOR YOUR INTERVENTION.

    IT HAS SOLVED MY PROBLEM.

    VERY GRATEFUL.

    WITH KIND REGARDS

    IBRAHIM DOKURUGU

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-01-17T08:57:00+00:00

    Hi Ibrahim,

    To use IF function, kindly check the information under Using IF to check if a cell is blank found in this article. It can definitely help you in using the If function in Excel.

    Hope this information helps. In case you need further assistance, kindly reply to us.

    Was this answer helpful?

    0 comments
  3. HansV 462.6K Reputation points
    2018-01-17T08:55:22+00:00

    How about

    =IF(COUNT(C7:D7)=0,"",SUM(C7:D7))

    If you use comma as decimal separator, it should be

    =IF(COUNT(C7:D7)=0;"";SUM(C7:D7))

    Please turn off your Caps Lock, writing in ALL CAPS is the Internet equivalent of shouting loudly...

    Was this answer helpful?

    0 comments