Help with if function
I've been searching for an answer for a while, and but I'm stalling out after getting only half the formula to work.
I have a table with the following:
A2 has the string "Yes"
A4 has a percentage that is calculated off a formula
I would to like a formula for A6 that checks to see if A2 has the string "Yes", and then populates A6 with the percentage from A4.
I can get the plain vanilla if statement to work fine, but when I try to reference cell A4 for the success message, I get an error.
Here's what's crashing out:
IF(EXACT(A2,"Yes"), A4,"NO")
Thanks for any help!