This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
I'm looking to calculate a field based on other fields (all in the same data row). So if column A value is NO return data from column F else return data from column G
Basically a formula such as:
IF [Column A]=NO,"[Column F]","[Column G]"
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Hi kelsurprise,
Thanks for posting in the community.
According to your description, please try this formula and check if it helps.
=IF([Column A], [Column G], [Column F])
When you have time, please feel free and come back to share the updates with us.
Regards,
George