If Cell is Blank (Though a Link), Hide Result, Else Normal Font

[Mary]

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.

 

[Gary''s Student]

The usual trick is to look at the reference and if it blank, use blank rather
than a value or formula:

=IF(Sheet1!L18="","",Sheet1!L18)

 

[Pete_UK]

I'm not sure why you insist on changing the font to white (you can do
this with conditional formatting) - just return "" if the condition is
met, otherwise return some other value.

Hope this helps.

Pete

 

[Mary]

I think I know what you mean...however, I wish for there to be a number shown
in AC13 (Day 5), then AC14 and AC15 should be blank, then there should be a
number shown again in AC16 (Day 6). Perhaps I have missed an additional "" in
my formula?

 

[Mary]

Okay, yes! I did put the "" well BEFORE the rest of that whole formula--and
of course now it is returns a 'blank' cell. Thank you for helping me see
through that most obvious solution--and so simple! Whew.

 

[Mary]

Sorry, but I'm not sure this works; it appears I lose month-to-date
cumulative projection #s in Column AC. If I change the formula in Cell AC14
to be

=IF(Z14="","",(IF(OR(AA14=0,AA14=""),AC13,AC13+($Q$20/$I$20)

the result in AC14, which is a MTD #, is fine, because there is a numeral
'5' in Cell Z14...but if I copy this formula down into Cell AC15, and when
Cell Z15 is blank in appearance/it is "", then I seem to lose the # that had
been accumulating up until
AC14.

Maybe the first part of my revised formula above is not correct...boy, I
can't seem to make it work.