| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a formula with conditions
How can I create a formula for the following:
if A2 is <= 25 then * D8 by B4, and if A2 is <=25 but =50 then *D8 by B5, and if A2 is<=50 but =100 then * D8 by B6? So essentially if A2 is 0-25 then multiply D8 (a constant) by .10 and if A2 is 25-50, then multiply D8 by .2 and if A2 is 50-100, then multiply D8 by .4 and if A2 is 100-200, then multiply D8 by .5 Thanks for any help. JP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a formula that meets 2 different conditions... | Excel Discussion (Misc queries) | |||
| Formula With Several Conditions | Excel Worksheet Functions | |||
| How do I create a formula that has circular conditions? | Excel Discussion (Misc queries) | |||
| How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
| Create a total based on multiple conditions is not giving correct. | Excel Worksheet Functions | |||
Threaded Mode
