You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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!


Posted on Oct 7, 2024 12:45 AM

Reply
3 replies

Help with if function

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.