If A1=Hourly
B1=Unit
C1=Tax
D1=Expenses
Put this in E2 and copy down.....

=IF(COUNT(A1:B1)=2,"ERROR",SUM(MAX(A1:B1),C1,D1)

Vaya con Dios,
Chuck, CABGx3


"G4" wrote in message
...
The columns across the top are Hourly or unit plus tax plus expenses i
want
the total to be a result of either "Hourly" or "Unit"
"CLR" wrote:

Please be a litte more detailed in describing your problem. "What" data
do
you have stored "where", and how do you wish to interrogate it?

Thanks,
Chuck, CABGx3



"G4" wrote:

How do i Ask for the same argument from either one of two columns (IE
Hour or
Unit + exp+tax )