Forum Discussion

Pam Turk's avatar
Pam Turk
Copper Contributor
May 10, 2018

If Formula proglem

Hi, I'm new to the if, isif and conditional formatting functions and trying to set up a forumula with no luck.  I've tried several things and keep getting errors.  Hoping someone can help.  What I'm trying to do is create a formula for:  If E18 is blank than F18 = D18; if E18 has a value, than F18 = 0.  

Any help is greatly appreciated.

 

Formulas & Functions
Need Help formula
  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    May 10, 2018

    Hi Pam

     

    Try this formula in F18:

     

    =IF(E18="", D18, 0)

     

    The first condition is your criteria.

    The second is if it's true then use D18 value.

    The third is if it's false then make F18=0.

     

    Cheers

    Damien

Resources