Help with my formula

New Contributor

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

3 Replies
What do you want to be shown in E4 if D4 is “No” or Blank?



Try this formula:



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



@Haytham Amairah 


Thank you for your help. It worked out how I wanted and has allowed me to learn a little.



Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies