using formula with several possible answers

J

jog398

I need to multiply colume C by $180.00 and then either what is in colume D,
E, or F to get the total I need. There are 3 different choices for an answer.
HELP
thanks
 
P

Pete_UK

You will need a multiple IF statement (or VLOOKUP, or CHOOSE). Can you
tell us what your conditions are to decide whether to use columns D, E
or F, and are these added on to C*180 or multiplied?

Pete
 
J

jog398

Pete, I need to multiply the square feet in colume C * $180.00cost * either
colume D(minor work).25 OR E(medium).50 OR F(major).75 and this is them times
10% to get the total cost. If I put zero's in 2 of the D,E,F colume I get
nothing.
Help!
 
J

JMB

How do you know if it is minor, medium or major work? Is there a specific
criteria or is it something you have to decide and fill in?

If you have to fill it in, I would put a 1,2, or 3 in column D to indicate
minor, medium, and major then

C*180*(0.25*D)*0.10
 
Top