Posts by Natalee

excel template

I have completed that step, but do not know how to save it back to template. Thanks

I want to add a auto number to my template that will increase by one each time it is open. I have called the cell invoicenumber.

:thanx: it worked

I've got a row called rate
a cell called night
a cell called weekday
a cell called weekend
a row called hours

I need a formula that will
If rate "n" multiply hours by night
If rate "WD" multiply hours by weekday
If rate "WE" multiply hours by weekend

Thanks

Thanks WillR that worked. :guitar: :thanx:

I want to use the if function. I am trying to run two logical tests. I have done it this way
=IF(Retail<=500,DeliveryCharge,0)*OR(Distance>=10,DeliveryCharge,0) the problem is it only works for one of the logical tests.