| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
if then function
I would like to create a formula to multiply the data in A1 by a percentage
based on the percentage in B1. So, if B1<80% then A1x10%, if B1 is 80% to 89% then A1x15%, if B1is 90% to 99% then A1x18% and if B1100% then A1x20%. Does anybody have a lot of experience with the if then function? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
| change function variable prompts?? | Excel Worksheet Functions | |||
| Counting Function Dilemma | Excel Worksheet Functions | |||
Threaded Mode
