I’ve got an excel file containing freight detail and I’d like to construct the following formula:
<colgroup><col width="64" span="10" style="width: 48pt;"></colgroup><tbody>
</tbody>
How is can I construct so that it is only one statement?
Thanks.
Bob
IF order # is between 100-199 and receiving location is one of the ten locations then - freight in | |||||||||
IF order # is between 300-390 and shipping location is one of the ten locations then - freight out | |||||||||
IF order # is between 800-899 and receiving lcoation is one of the ten locations then - freight transfer |
<colgroup><col width="64" span="10" style="width: 48pt;"></colgroup><tbody>
</tbody>
How is can I construct so that it is only one statement?
Thanks.
Bob