Calculate new price with conditions

M

matt4003

Hello,

I would like it to =B1 which is the original price. If no "X" in A2:A
then there are no adders to the price.

It is kinda like buying a car. The basic price is $20K.
to add a sunroof costs 5%
to add better rims cost 2%
etc.

If you add both a sunroof and rims your final price will be $21.4K.

Does that make sense?

Thanks,
Mat
 
F

Frank Kabel

Hi
you may provide some mor details where you store your
percentages and what is in A2:A5?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate new price with conditions 2
How do I perform calculation within IF statement? 4
Calculate new price with conditions 2
Another solution for multiple embeeded IF 7
Automatically copy formula in column when adding new row.... 2
I need a formula for some calculations... 1
Help needed to write UDF to calculate value based on 8 conditions 2
A difficult conditonal calculation 0

Top