Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
IF excel formula help
![](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)
Anonymous
Hello! I'm still learning excel and this feels a little advanced for me, so hoping you can help.
If someone types Yes or No into a cell (lets call is G16), I'd like the next cell (H16) to have formula that looks at that, and if it says Yes then it multiplies the figure in another cell by 2 (lets call that cell F16). If it says no, it doesn't multiply it by anything and just shows the total from F16.
Example 1:
F16: 20
G16: Yes
H16: 40 (it said yes so has multiplied 20*2)
Example 2:
F16: 20
G16: No
H16: 20 (it said no so just shows 20)
Thank you kindly.
Microsoft 365 and Office | Excel | For business | Windows
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.