I'm not even sure whether this is possible.

I have a pick list set up but I would like for the 'Deposit Amount' column to 'look' at the 'Credit Terms' column, then make a calculation based on content of the cell.

Eg. If the credit terms are '10-30-60' I would like the value in the 'Deposit Amount' column to show 10% of the value in 'Total Amount Due' column.
It's pretty simple I think - But I can't seem to crack it (obviously doing something wrong) > =IF(G5=Sheet2!C2,"=SUM(/100*10)")


Temp.xlsx

Thanks a bunch for any help.

Linnylops