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 ...
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

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

    Thank you so much!

    • Damien_Rosario's avatar
      Damien_Rosario
      Silver Contributor
      May 10, 2018
      A pleasure Pam.

      Wishing you all the best!

      Cheers
      Damien

Resources