I'm new to writing formulas in Excel, and I can't figure out how to have nothing change in one cell if the contents of another don't meet my criteria.
IF (the value in B1) ISODD, C1=B2; if the value in B1 is NOT odd, take no action.
How can I do that? I'm using :( Excel 97!