Hi all,

I'm so new in excel scripting and i need simple help.

I've got a sheet with the following info.

Price - Bulk Price - Total price

And i need to calculate the total price (totalprice = (PRICE OR bulkPRICE * 2.5)

If Bulkprice contains a number i need to use that field but if it's empty i need to use Price.

How can i do this?