Forum Discussion

noelosborne1's avatar
noelosborne1
Copper Contributor
Apr 05, 2019
Solved

Help with my formula

Hello all, I need help correcting this formula. In cell E4, I wish to show 50% of the value from C4 if D4 has the word YES.  Thanks for your assistance.  
excel
  • Haytham Amairah's avatar
    Haytham Amairah
    Apr 05, 2019

    Hi,

     

    Try this formula:

    =IF(D4="yes",C4*50%,0)

     

    It will return 50% of the value of cell C4 when the value of D4 is yes, otherwise it will return 0.

     

    Hope that helps

     

    noelosborne1

Twifoo's avatar
Twifoo
Silver Contributor
Apr 05, 2019
What do you want to be shown in E4 if D4 is “No” or Blank?