Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using formula with several possible answers
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using formula with several possible answers
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using formula with several possible answers
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! "Pete_UK" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using formula with several possible answers
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 "jog398" wrote: 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! "Pete_UK" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
sum formula not working, producing incorrect answers Excel 2003 | Excel Discussion (Misc queries) | |||
Recalculating Formula - Getting the wrong answers | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |