Hi

I am trying to work out the formula I would need for the same cell to copy the value from another cell if the text "PTI" is input but if a value is put in the same cell instead of "PTI" to then multiply that value by the labour rate I have put in a different cell

This is what I have put, its working for calculating the hours but when I put PTI in the cell it comes up with a value error
=IF(A7>=0,A7*B5)*OR(A7="PTI",B4)


Cost Allocations.xls