| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with end results Microsoft Office Excel 2003
=IF(D4<8.99,"*55%",IF(D4=8.99,"*25%",IF(D48.99,"* 55%*")))
my answer =25%. I need the answer to go a step further and multifply the cell by the % what do I need to add to the formula to get my answer? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help with end results Microsoft Office Excel 2003
Do you mean
=D4*IF(D4<8.99,55,IF(D4=8.99,25,IF(D48.99,55)))% If this post helps click Yes --------------- Jacob Skaria " wrote: =IF(D4<8.99,"*55%",IF(D4=8.99,"*25%",IF(D48.99,"* 55%*"))) my answer =25%. I need the answer to go a step further and multifply the cell by the % what do I need to add to the formula to get my answer? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help with end results Microsoft Office Excel 2003
On Thu, 9 Jul 2009 09:19:01 -0700,
wrote: =IF(D4<8.99,"*55%",IF(D4=8.99,"*25%",IF(D48.99," *55%*"))) my answer =25%. I need the answer to go a step further and multifply the cell by the % what do I need to add to the formula to get my answer? You also need to subtract some stuff: =D4*IF(D4<8.99,55%,IF(D4=8.99,25%,IF(D48.99,55%)) ) --ron |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help with end results Microsoft Office Excel 2003
YES, thank you, thank you , thank you. I was about ready to give this up
" wrote: =IF(D4<8.99,"*55%",IF(D4=8.99,"*25%",IF(D48.99,"* 55%*"))) my answer =25%. I need the answer to go a step further and multifply the cell by the % what do I need to add to the formula to get my answer? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help with end results Microsoft Office Excel 2003
Try this:
=((D4<8.99)*0.3+0.25)*D4 " wrote: =IF(D4<8.99,"*55%",IF(D4=8.99,"*25%",IF(D48.99,"* 55%*"))) my answer =25%. I need the answer to go a step further and multifply the cell by the % what do I need to add to the formula to get my answer? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to copy and paste from BRIO to Microsoft Office Excel 2003. | Excel Discussion (Misc queries) | |||
| text is truncated in Microsoft Excel chart in Office 2003 | Charts and Charting in Excel | |||
| Microsoft Office XP excel 2003 | Excel Discussion (Misc queries) | |||
| Want to buy just EXCEL 2003 not the entire microsoft office suite | Excel Discussion (Misc queries) | |||
| Is Monotype Sorts Font available in Excel 2003(Microsoft Office S. | Excel Discussion (Misc queries) | |||
Linear Mode
