Assuming that only one or the other will contain an entry:

=#of units * MAX(old work price, new work price)

=A1*MAX(B1,C1)

--
Biff
Microsoft Excel MVP


"broadoak8" wrote in message
...
I have 4 columns of data ( #of units, old work price, new work price, &
total). How do I multiply number of units by either old work price, or
new
work price, based on column where data is entered?