You will need a multiple IF statement (or VLOOKUP, or CHOOSE). Can you
tell us what your conditions are to decide whether to use columns D, E
or F, and are these added on to C*180 or multiplied?

Pete