G
G4
How do i Ask for the same argument from either one of two columns (IE Hour or
Unit + exp+tax )
Unit + exp+tax )
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Anne Troy
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
=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
C
CLR
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
you have stored "where", and how do you wish to interrogate it?
Thanks,
Chuck, CABGx3
G
G4
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"
the total to be a result of either "Hourly" or "Unit"
C
CLR
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
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