Hello. I have two sets of data tables and then below I have formulas for the variance. I would also like to have formulas that calculate the percentage variance but without having to create another section. Is it possible to have one cell that says either absolute or %, and that will make all the formulas change based on the input? Thanks.
Bookmarks