software

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

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?

PetePete, 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!

quot;Pete_UKquot; wrote:

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

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

quot;jog398quot; wrote:

gt; Pete, I need to multiply the square feet in colume C * $180.00cost * either
gt; colume D(minor work).25 OR E(medium).50 OR F(major).75 and this is them times
gt; 10% to get the total cost. If I put zero's in 2 of the D,E,F colume I get
gt; nothing.
gt; Help!
gt;
gt; quot;Pete_UKquot; wrote:
gt;
gt; gt; You will need a multiple IF statement (or VLOOKUP, or CHOOSE). Can you
gt; gt; tell us what your conditions are to decide whether to use columns D, E
gt; gt; or F, and are these added on to C*180 or multiplied?
gt; gt;
gt; gt; Pete
gt; gt;
gt; gt;