Im setting up a excel spread sheet so i can bill my customers i got most of
the codes put it I have one problem I can't program a code so when i put in
the equiptment the cost of the use comes in the cell when i put the unit
number in .
i have the unit as a drop cell but i want the unit rate to show up with it.
Can anyone help me?I have the list to the far left for all the machinery
operators and the units and unit price

Unit Machine Qty Unit Cost Operator Travel
Number & Model Rate Amount
Bocat #2 8 hours 750 6000 dave

If your columns are set up like this on the sheet:

A B C D E
F
1 Unit Machine Qty Unit Cost Operator Travel
Number & Model Rate Amount
2 Bocat #2 8 hours 750 6000 dave

Then put this in cell E2 and copy it down to the bottom of your data range.

IF(a2"", c2*d2, "")





"Itsalmostfriday" wrote:

Im setting up a excel spread sheet so i can bill my customers i got most of
the codes put it I have one problem I can't program a code so when i put in
the equiptment the cost of the use comes in the cell when i put the unit
number in .
i have the unit as a drop cell but i want the unit rate to show up with it.
Can anyone help me?I have the list to the far left for all the machinery
operators and the units and unit price

Unit Machine Qty Unit Cost Operator Travel
Number & Model Rate Amount
Bocat #2 8 hours 750 6000 dave

Forgot the equal sign:

=IF(a2"", c2*d2, "")



"Itsalmostfriday" wrote:

Im setting up a excel spread sheet so i can bill my customers i got most of
the codes put it I have one problem I can't program a code so when i put in
the equiptment the cost of the use comes in the cell when i put the unit
number in .
i have the unit as a drop cell but i want the unit rate to show up with it.
Can anyone help me?I have the list to the far left for all the machinery
operators and the units and unit price

Unit Machine Qty Unit Cost Operator Travel
Number & Model Rate Amount
Bocat #2 8 hours 750 6000 dave