Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par Imran Ahmed , Planning Manager , Citiscape KSA Abdullah abunayyan holding
Date de publication: 2016/08/08
Firas Shahadi
par Firas Shahadi , Human Resources Director , SAUDI UNION

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

 

Jehanzeb Khan
par 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

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?