Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the “What If” condition in excel formulas?

user-image
Question added by Imran Ahmed , Manager-Planning & Delay Analyst , Nesma United Industries (NUI) Saudi Arabia
Date Posted: 2016/08/08
Firas Shahadi
by Firas Shahadi , Human Resources Director , SAUDI UNION

we are using what if analysis to check on all the scenarios for certain situation.

 

Jehanzeb Khan
by Jehanzeb Khan , Compounds / Facilities Manager , Confidential

The IF function is one of the most popular and useful functions in Excel. You use the IF function to ask Excel to test a condition and to return one value if the condition is met, and another value if the condition is not met.

Moreover, The IF function is one of Excel's logical functions that evaluates a certain condition and returns the value you specify if the condition is TRUE, and another value if the condition is FALSE.

I'm sorry I didn't quite get your question but from my understanding of Ms Excel, the IF function is a logical function of MS Excel that evaluates a certain condition and returns the value you specify if the condition is TRUE, and another value if the condition is FALSE.

The syntax for Excel IF is as follows:  IF(logical_test, [value_if_true], [value_if_false]) 

 

More Questions Like This