Oct 7, 2011

I have three formula in a spreadsheet, all of which should return a number (which they do) or show blank. However, two of the formula return 'FALSE'. The formula are as follows:

1 Which returns a number or 'FALSE'

=IF(A15="2",(""),IF('Doorset schedule'!N20="l",(""),IF('Doorset schedule'!AY20="l",(""),

IF('Doorset schedule'!AZ20="l",(""),IF('Doorset schedule'!BA20="l",(""),IF('Doorset schedule'!BB20="l",(""),

IF('Doorset schedule'!BC20="l",(""),IF('Doorset schedule'!CN20="l",(""),IF('Doorset schedule'!S20="l",(3),

IF('Doorset schedule'!T20="l",(6),IF('Doorset schedule'!U20="l",(6),IF('Doorset schedule'!W20="l",(4)))))))))))))

2 Which returns a number or remains blank (ie works OK)

=IF(A15="2",(""),IF('Doorset schedule'!N20="l",(""),IF('Doorset schedule'!AW20="l",(""),IF('Doorset schedule'!AX20="l",(""),

IF('Doorset schedule'!CN20="l",(""),IF(AND('Doorset schedule'!AY20="",

'Doorset schedule'!AZ20="",'Doorset schedule'!BA20="",'Doorset schedule'!BB20="",

'Doorset schedule'!BC20=""),(""),IF(AND('Doorset schedule'!S20="l",'Doorset schedule'!

[Code] ......

3 Which returns a number or 'FALSE'

=IF('Doorset schedule'!$CW20="N",(" "),IF('Doorset schedule'!$CX20="1",("1"),

IF('Doorset schedule'!$CY20="2",("2"),IF('Doorset schedule'!$CZ20="4",("4")))))

View 2 Replies
View Related