I have 5 tanks (100/1001, 100/1002, 100/1003, 100/1004, 100/1005) which we
send product into each one, not necessarily on the same range. The formula
has the tank number and the tank size. However, it has 3 different ways to
write these tanks on the cells.
100/1001, 100-1001 or 01

If my tank is 100/1001, the amount of product from that tank has to be
multiplied by the tank size, if not, the function will look for other tank,
and go on.
Simplifying:

=IF(AN17="100/1001",AN17="100-1001",AN17="01"),(AN18-AN19)*10380, €œ other
tank€�)

The formula I came with is: ( it is not working)

=IF(OR(AN17="100/1001",AN17="100-1001",AN17="01"),(AN18- AN19)*10380,
IF(OR(AN17="100/1005",AN17="100-1005",AN17="05"),(AN18- AN19)*9636,
IF(OR(AN17="100/1002",AN17="100-1002",AN17="02"),(AN18-AN19)*2415+4141,
IF(OR(AN17="100/1003",AN17="100-1003",AN17="03"),(AN18-AN19)*988+1326,
IF(OR(AN17="100/1004",AN17="100-1004",AN17="04"),(AN18-AN19)*430.9,
"ERROR")))))

I dont know if the OR function works with 3 logical.

Can somebody assist me please?



--
Thanks.........