Setting up a price list

[G4]

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

[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

"G4" <[email protected]> wrote in message
news:[email protected]...
> How do i Ask for the same argument from either one of two columns (IE Hour
> or
> Unit + exp+tax )

[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



"G4" wrote:

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

[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"
"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 )

[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


"G4" <[email protected]> wrote in message
news:[email protected]...
> 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 )