# Homework Solution: Revenue Cost 1500 1000 500 500 Over 1000 Equal 00 Under 10…

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 10

Answer: For the given problem the formula is as follo

How 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

## Expert Acceptance

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)