Set cell value if adjecent cell value is greater than 0
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
|