Formule logice AND,OR, functiile IS de verificare,functia IF

Ce poate intra intr-o celula in general:

Operatori de comparatie lista completa exemplificata:

Evaluarea mai multor expresii folosind operatorii de comparatie:

Functia AND – intoarce true doar cand toate conditiile logice separate de virgula in cadrul formulei logice sunt adevarate.

In caz contrar intoarce false.

Exemple functia AND:

Exemple functia OR:


Exemple functia ISTEXT:

Exemple functia ISNUMBER:

Exemple functia ISLOGICAL:

Exemple functia ISBLANK:

Functiile ISERROR,ISERR,ISNA:

Functiile ISNONTEXT,ISEVEN,ISODD:


IF logical test, value_if_true, value_if_false:

IF(ISTEXT(cell),”text”,”number”)

IF(ISNUMBER(cell),”number”,”text”)

Formatarea conditionala la formule logice

Dorim sa coloram cu rosu daca avem pierdere si cu verde daca avem castig in ex de mai jos cu if: ->asta e formatarea conditionala

Daca marim valoarea veniturilor :

Acum facem conditional formatting a.i Net loss sa fie o celula rosie , iar aceeasi celula sa devina verde cand avem Net Income:



Scurtatura la conditionnal formatting este alt si o si d.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: