I've been handed this MacBook Air to try and organise some data for a relative's business but I've been an Excel user for decades. I'm making progress but it's hard. Is there a way to step through a formula like nested ifs to find the syntax error, and how to I change data format in the cells? I can go into the Format pane and select what I want but as soon as I move to another cell it reverts back to automatic. This is confusing me in a formula where a digit might be read as text or number...