Hello.

I would like the result of a formula to show ("show" as normal font) if
something is true, and I'd like it to not show/not print (be in white font)
if it's false.

In my worksheet, Cell Q20 is the total month's sales projection, and Cell
I20 is the total number of workdays in the month. The sheet also has these
columns:

Col Z: Workday Number (Z9:Z40 are links to another sheet; will show either a
numeral 1 through approx 20 or else be blank if the linked-to sheet's cell
value is blank)

Col AA: Daily Actual Sales (AA9:AA40 are links to a datasheet; may be <0, 0
or ))

Col AB: Month-to-date Actual Sales (sum of to-date values; the calc in AB16,
for example, is the sum of AA9:AA16)

Col AC: MTD Projection Sales


Currently, Cell AC13 is:

=IF(OR(AA13=0,AA13=""),AC12,AC12+($Q$20/$I$20)

Cell Z13 contains the number 5, for Workday number 5, and so it is good that
a MTD Projection # appears in Cell AC13.

Cell AA14 does not have a number shown/it is blank; it does link to a cell
on another sheet, and that linked-to cell is blank. I would like Cell AC14 to
be in white font/to NOT appear, because there are no Daily Sales and no
Workday value shown in Row 14. There are no Daily Sales and no Workday in Row
15, either, so I would like AA15 to also be blank.

Since Daily Sales and Workday next appear on Row 16, I would like AC16 to be
in normal/black font.

Does this make sense? Would I Should I use a different formula in AC13?

Sorry if this is too much info...just trying to be thorough.

Thank you.