Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How many parameters we should insert inside the IF function or formula to work probably? and can they be incremented somehow?

user-image
Question added by Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL
Date Posted: 2015/03/26
Ahmed Maher allam
by Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL

don't forget to vote the answers and the questions to follow up and know the Right answers.

 

FITAH MOHAMED
by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

NICE QUESTION 

ANSWER 

Three

Form

IF =(LOGICAL_TEST;VALUE_IF_TRUE;VALUE_IF_FALSE)

1-Logical test "condition "

2-Value if condition true

3- Value if condition false

example

 

a2=12

a3=17

a4=15

=if(a2<15:"good";"excellent")

Then 

*- they can be incremented conditions by using functions such " and & or "

example 

=if(and(a2<15;a3<15);"good";"excellent")

=if(or(a2>=15;a3>15);"have excellent";"do not have excellent")

*- they can be incremented  many conditions and many results by using  if function

example

=if(a2<15;"good";if(a2<17;"very good";"excellent"))

and you can make more complicated formulas

thanks for invitation 

 

More Questions Like This