Hi everyone.

I am trying to set up a self calculating invoice in Excel.
Each row in the invoice shows the Service type, a description, the price per
unit, the quantity and the total price.

I am trying to have the qty field automatically set itself to one if it
detects a price value in the price per item field. can this be done?

Thanks

Use an IF fomula. See example under help for the IF statement.

"SaigonJeff" wrote:

Hi everyone.

I am trying to set up a self calculating invoice in Excel.
Each row in the invoice shows the Service type, a description, the price per
unit, the quantity and the total price.

I am trying to have the qty field automatically set itself to one if it
detects a price value in the price per item field. can this be done?

Thanks

Thanks Joel!

You were right! I was looking in th wrong place for the answer all this time

In the taget cell I place the following;

=IF(D60,1,"")

Works perfectly!

Many thanks!

"Joel" wrote:

Use an IF fomula. See example under help for the IF statement.

"SaigonJeff" wrote:

Hi everyone.

I am trying to set up a self calculating invoice in Excel.
Each row in the invoice shows the Service type, a description, the price per
unit, the quantity and the total price.

I am trying to have the qty field automatically set itself to one if it
detects a price value in the price per item field. can this be done?

Thanks