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 want a cell to state Yes or No if a value in one cell, is more or less than value of another cell. Screenshot is best example to go off - as it states to show whether cell G10 is more than D11, it says Yes - =IF(G11>D11, "Yes").
The problem is, it states all cells as Yes even when the equation isn't true, as Cell D16 is 486, 14 values below Cell G16 which is 500 yet it still states Yes.
Can anyone advise?
Shaun
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
You formula only specifies the "value-if-true" part. If the condition is false, Excel will then return FALSE.
Change the formula to either
=IF(G16>D16,"Yes","No")
or
=IF(G16>D16,"Yes","")
depending on your preference.
Hi HansV,
That's what I was insinuating sorry. So as it stands, the formula in H15 =IF(D15>G15,"Yes"). But the value shows as FALSE. See image again, how do I reset calculation as automatic sorry?
It appears irregardless of cell values, all cells show as Yes or False. So maybe it is an automatic error that needs aligning.
G16 = 500 is larger than D16 = 486 so =IF(G16>D16,"Yes") should indeed return "Yes".
The result in many other rows, such as rows 10, 11, 12 looks wrong.
Are you sure that Calculation has been set to Automatic?