Forum Discussion
Error Combining Multiple ifs with Logical Test
[ Spoiler ]
Great thank you, that did work for that instance. Would it be possible to use a NAME rather than a number in A4479? Will Ifs validate a name and not just a number?
You can compare with a text. Then you have to put this in quotation marks. "RJR". If you want to work with a name from the name editor, then the result of the formula from the name or the fixed content would be compared. So it also goes.