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
Return Cost 1500 1000 500 500 Over 1000 Resembling 00 Underneathneath 10
For the dedicated example the formula is as follows
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)(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)