Apr 05 2019 03:38 PM
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.
Apr 05 2019 08:40 PM
Apr 05 2019 08:41 PM
SolutionHi,
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
Apr 08 2019 02:34 AM
Thank you for your help. It worked out how I wanted and has allowed me to learn a little.
Noel
Apr 05 2019 08:41 PM
SolutionHi,
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