Something like this, I reckon:
In B2, copied down: =IF(A2="","",IF(A240,A2*64,A2*46))
Adapt to suit. Any good? hit the YES below
--
Max
Singapore
---
"Brian" wrote:
Does anyone know how to create a cell that will calculate whether the number
in the orginal cell is above or below 40. If above 40 it will calculate at
$69.00 for anything over if below it will calculate at $46.00