How can I use Excel, IF to make logic "over(greater than ), equal, under(less than)" , at same time?
For example, Column C is revenue, Column D is Cost. In the same row, IF
C>D “over”
C=D “equal”
C<D “under”

Revenue Cost 1500 1000 500 500 Over 1000 Equal 00 Under 10How can I representation Excel, IF to create logic “over(senior than ), resembling, underneath(short than)” , at selfselfselfcorresponding season?

For development, Column C is return, Column D is Cost. In the selfselfselfcorresponding dignity, IF

C>D “over”

C=D “equal”

C<D “under”

Return Cost 1500 1000 500 500 Over 1000 Resembling 00 Underneathneath 10

**Answer:**

For the dedicated example the formula is as follows

**=IF(C2>D2,”Over”,(IF(C2<D2,”Under”,”Equal”)))**

and dedicate the selfselfselfcorresponding to every dignitys.

The syntax is **If(condition,[value_if_TRUE],[value_if_FALSE])**

**First the “if statement” evaluates the “condition”, if the case is TRUE it goes through “[value_if_TRUE]”, inadequately it goes through “[value_if_FALSE]”**

**In our Development**

**=IF(C2>D2,”Over”,(IF(C2<D2,”Under”,”Equal”)))**

If (C2>D2)(The cell rate in C2 is senior than the cell rate in D2) then **“Over”** is the issue.

Otherwise, it goes to **[Value_if_FALSE]** section. It finds another case here. i.e if(C2<D2) (The cell rate in C2 is short than the cell rate in D2) then **“Under”** is the issue. If(C2<D2) is besides FALSE, it goes to its **[Value_if_FALSE]** section which is **“Equal”.** (If C2>D2 is falsity, and C2<D2 is falsity, then C2 must be resembling to D2)