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 |
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 |
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 |
All times are GMT +1. The time now is 06:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com