How to Avoid Running a Formula From a Common Spreadsheet Under Certain Conditions

Question

I am trying to run multiple scenarios in a financial model that all originate from one common set of formulas in a singular sheet. Simultaneously, I would like the results for all non-active scenarios (i.e. if the governing condition is not met) to remain displayed in their respective location instead of a "0".

My goal is to (i) avoid using the "COPY-PASTE" function for each scenario that doesn't meet the active criteria and (ii) leave all the formulas (which draw from the same spreadsheet) in their respective tables (Which summarize each scenario). While a traditional "IF" statement could work, I get hung up on what to put in the "FALSE" category seeing as I do not want to return "0". In the end, I have copy-pasted the results table three different times, and hope to display all results simultaneously without having to copy-paste the numbers.

Thanks.

Answer 1

If you want to use an IF statement but was to return "blank" value instead of false, you can use a Null String ("").

For example:

=IF(A1=B1,"They Match!","")

This will return They Match! if cells A1 and B1 match, otherwise the cell will remain blank.

This is more information about how to use the IF statement in Excel.