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 , CBK - G&D - AXIS-olutions
Date Posted: 2015/03/26
Joseph Alfred Villanueva
by Joseph Alfred Villanueva , Project Manager , RSTN Consulting

It could be multiple. But for very long formula, I would suggest to write it in VB or segment it using multiple cells in order to avoid getting lost or confused.

Ahmed Maher allam
by Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions

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

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.