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
    Revenue Cost 1500 1000 500 500 Over 1000 Equal 00 Under 10

    Expert Answer

     
    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

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

    Expert Acceptance

     

    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)