Microsoft%20Excel%20Interview%20Questions%20and%20Answers

Question: What is the "What If" condition in excel formulas?

The “What If” condition is used to change the data in Microsoft excel formulas to give different answers.

Example: You are buying a new car and want to calculate the exact amount of tax that will be levied on it then you can use the “What If” function.  For instance there is three cells A4,B4 and C4. First cell says about the amount, second cell will tell about the percentage (7.5%)  of tax and final cell will calculate the exact amount of tax.