Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Microsoft Excel If Statement?

Here is what I have so far:

=IF(B4<100, "You need (100-$B$4) more stalemates to get the Deadlock Honor.", "#N/A")

I have my input set up in cell B4.

For example, if the user puts the number 24 in the input cell, I want the output to read: "You need 76 more Stalemates to get the Deadlock Honor."

I need the formula to read as an IF statement because if the user puts in a number higher then 100, I want it to read "#N/A" for the "false" part of the statement.

I need the formula to be set up for calculating a simple subtraction inside the "true" part of the statement.

How would I go about writing this code?

1 Answer

Relevance
  • 8 years ago
    Favorite Answer

    Copy this formula and paste it into a cell:

    =IF(B4<100, "You need "&(100-B4)& " more stalemates to get the Deadlock Honor.", "#N/A")

    . .

Still have questions? Get your answers by asking now.