Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If on an If
I have added an if statement under X5 so that if another cell had avalue then
it wold show here. I have then written anoher if statement under X5 points =IF(V30,11,""). This should not return 11 in this example as X5 does not have a value, the cell just has =IF(E30,E3,"") How do I get the X5points to return nil. X5 X9 X12 VT7 Other X5 Points X9 points X12 2200 11 17 17 12 -- Matty |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If on an If
Hi,
The problem with your formula was a "," instead of "." after the 0, try =IF(V30.11,"") if this helps please click yes, thanks "litm" wrote: I have added an if statement under X5 so that if another cell had avalue then it wold show here. I have then written anoher if statement under X5 points =IF(V30,11,""). This should not return 11 in this example as X5 does not have a value, the cell just has =IF(E30,E3,"") How do I get the X5points to return nil. X5 X9 X12 VT7 Other X5 Points X9 points X12 2200 11 17 17 12 -- Matty |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If on an If
I don't think that =IF(V30.11,"") will give you the desired result !
There's probably a better solution but I always use something like: =SUMIF(V3,"0",V3) "Eduardo" wrote: Hi, The problem with your formula was a "," instead of "." after the 0, try =IF(V30.11,"") if this helps please click yes, thanks "litm" wrote: I have added an if statement under X5 so that if another cell had avalue then it wold show here. I have then written anoher if statement under X5 points =IF(V30,11,""). This should not return 11 in this example as X5 does not have a value, the cell just has =IF(E30,E3,"") How do I get the X5points to return nil. X5 X9 X12 VT7 Other X5 Points X9 points X12 2200 11 17 17 12 -- Matty |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|