May 13 2022 08:37 AM
Hi all where have I gone wrong with this =IF(AND(D339=0,$Q$337=0),Q339"",IF(AND(D339=VAT20_1,$Q$337),Q339"Y",IF(AND(D339=VAT20_3,$Q$337),Q339"Y",))) excel says it is not a formula.
May 13 2022 08:46 AM
=IF(AND(D339=0,$Q$337=0),Q339"",IF(AND(D339=VAT20_1,$Q$337),Q339"Y",IF(AND(D339=VAT20_3,$Q$337),Q339"Y",)))
What are you trying to return with the red parts? If you want to concatenate something with cell Q339 you should use Q339&"Y"
And regarding the blue parts, are these named ranges or texts? If these are texts you should put quotations marks around them, like "VAT20_1"
May 13 2022 08:52 AM
Hi the blue parts are named ranges and the red ones are where i want my result either do nothing or the letter Y@Riny_van_Eekelen
May 13 2022 09:01 AM