Ok I know this has to be easy but im having a real tough time making the "0" value of a formula display as "-" instead. Im using Excel 2008 on a Mac fyi.
I have 2 tabs in my workbook,
the first is worksheet that i use to enter my data
the second tab has all the formulas and the end result of data im looking to print out.
on the second tab im using formulas like " =Data!B2 " (data being the name of my worksheet tab)
on the second tab I would like to display a "-" if there is no data present on the worksheet whereas what i have displaying now is "0"
Excel help said to wrap the formula with =IF(ISERROR(old_formula),"-",old_formula)
but to no avail it gives me another error saying that the formula contains an error
I attached a copy of the workbook template for reference
Help Please!
Bookmarks