I am needing some help on a formula, that I believe needs to be a If/Then formula, but not sure. I am tracking sells for a client. Each day there is an Goal, Actual, Last Year, and a Budget box. Each of them have a +/- box to show how they preformed. Currently the +/- box shows a negative number for the days that have not happened because there is not anything in the Actual box. What is the formula to have the +/- box show a "-" until the Actual number is entered. I know this is an aesthetics thing, but it drastically clogs up the look of the spreadsheet.


A B
1 Goal $5,076.40
2 Actual
3 $ +/- -$5,076.40
4 Last Year $2,929.43
5 $ +/- -$2,929.43
6 Budget $3,356.47
7 $ +/- -$3,356.47