| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE
Why am I getting #VALUE in the cell when E15 is blank in the below formula?
=IF(E15="","",IF(E15="1x",(SUM(G15*1)),IF(E15="3x" ,(SUM(G15*3)),IF(E15="6x",(SUM(G15*6)),IF(E15="10x ",(SUM(G15*10)),0)))))*4.5 I thought that the IF(E15="","" portion of the formula would keep that from appearing. Any ideas? Thanks much! -- Krista |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE
When E15 is blank the IF function does indeed return a blank but then you are trying to multiply that blank by 4.5, which will give you a #VALUE! error. If you always want to multiply the number in E15 (without the "x") by G15 and then by 4.5 perhaps try =IF(E15="","",G15*SUBSTITUTE(E15,"x","")*4.5) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=558685 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE
Thanks!
-- Krista "daddylonglegs" wrote: When E15 is blank the IF function does indeed return a blank but then you are trying to multiply that blank by 4.5, which will give you a #VALUE! error. If you always want to multiply the number in E15 (without the "x") by G15 and then by 4.5 perhaps try =IF(E15="","",G15*SUBSTITUTE(E15,"x","")*4.5) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=558685 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE
Oh Yeah, that formula is much much better.
Thanks again! -- Krista "daddylonglegs" wrote: When E15 is blank the IF function does indeed return a blank but then you are trying to multiply that blank by 4.5, which will give you a #VALUE! error. If you always want to multiply the number in E15 (without the "x") by G15 and then by 4.5 perhaps try =IF(E15="","",G15*SUBSTITUTE(E15,"x","")*4.5) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=558685 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
