You are reading a single comment by @pifko and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
pifko
In sheet 1 there are names in column A and in the other columns a letter, phrase, or null/empty to indicate things.
For only one of my IF formulas for one column - column I - it's not working.
Any typical reasons?
IFS('workbook 1'!I2="x", $B$2, 'workbook 1'!I2="bum", $B$2)