| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with conditional formula...
I need some help with a conditional formula. Here is my fomula now.
=IF(B3=3,C8*3.75). The cell B3 can have either 3, 4, 5 or 6 as the value. How can I adjust how much C8 is multiplied by depending on whether B3 has a 3-6 value? Or in other words, how can I attach another condition onto this formula? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with conditional formula...
=if(B3=3,C8*[condition1],IF(B3=4,C8*[condition2],IF(B3=5,C8*[condition3],C8*[condition4])))
Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. " wrote: I need some help with a conditional formula. Here is my fomula now. =IF(B3=3,C8*3.75). The cell B3 can have either 3, 4, 5 or 6 as the value. How can I adjust how much C8 is multiplied by depending on whether B3 has a 3-6 value? Or in other words, how can I attach another condition onto this formula? Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with conditional formula...
On Feb 5, 9:17 am, Dave F wrote:
=if(B3=3,C8*[condition1],IF(B3=4,C8*[condition2],IF(B3=5,C8*[condition3],C8*[condition4]))) Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. " wrote: I need some help with a conditional formula. Here is my fomula now. =IF(B3=3,C8*3.75). The cell B3 can have either 3, 4, 5 or 6 as the value. How can I adjust how much C8 is multiplied by depending on whether B3 has a 3-6 value? Or in other words, how can I attach another condition onto this formula? Thanks. Thats it. Thanks Dave! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Conditional Formatting Against a Formula - not it's result | Excel Discussion (Misc queries) | |||
| need a conditional formula to generate numbers divisible by 4 between a given starting no. & end No. | Excel Worksheet Functions | |||
| Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
| Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Linear Mode
