| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula
I need a formula that allows for two different percentages based on reaching
a certain limit. I tried the following: =IF(cell#35,cell#*.0625),If(cell#<35,cell#*.0725) I got the VALUE# error message. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excel formula
Try this,
=IF(A1<35,A1*0.0725,A1*0.0625) Note that this will multiply 35 * 0.0625. If you want to force it the other way try =IF(A1<=35,A1*0.0725,A1*0.0625) Mike "asdreifus" wrote: I need a formula that allows for two different percentages based on reaching a certain limit. I tried the following: =IF(cell#35,cell#*.0625),If(cell#<35,cell#*.0725) I got the VALUE# error message. Any ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excel formula
If those are the only two choices................
=IF(A135,A1*0.0625,A1*0.0725) What do you want if A1 is exactly 35? Gord Dibben MS Excel MVP On Thu, 14 Aug 2008 12:48:16 -0700, asdreifus wrote: I need a formula that allows for two different percentages based on reaching a certain limit. I tried the following: =IF(cell#35,cell#*.0625),If(cell#<35,cell#*.0725 ) I got the VALUE# error message. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Hybrid Mode
