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

Perhaps something like:
=if(isblank(a1),b1+c1+d1,a1*e1)
where a has hours, b is unit, c is exp, d is tax, and e is hourly rate.

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"G4" wrote in message
...
How do i Ask for the same argument from either one of two columns (IE Hour
or
Unit + exp+tax )

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 )

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 )

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 )