SOLVED

Help with my formula

Copper 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?
best response confirmed by noelosborne1 (Copper Contributor)
Solution

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

@Haytham Amairah 

 

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

 

Noel

1 best response

Accepted Solutions
best response confirmed by noelosborne1 (Copper Contributor)
Solution

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

View solution in original post