Hide answer if it is £0.00

[Andy Laycock]

Hi,

I am creating a hire sheet so that people can hire equipment. I have a table
with all the equipment, price per unit day, number of units required and
number of days required so it calculates a final value.

This has left my end total column with loads of £0.00 values. How can I hide
these so that a value only occurs when I enter a booking for that piece of
equipment.

I'm sure it's simple but I couldn't find anything looking through the Google
achieves

Cheers

Andy

 

[Andy B]

Hi

You can do this in a number of ways.
One way is to go to Tools/Options/View and uncheck 'zero values'.
Another is to enclose the formula that gives you the zero in an IF
statement. So if the cell was =SUM(C2:C10) you could change it to:
=IF(SUM(C2:C10)<>0,SUM(C2:C10),"")

Andy.

 

[Freemini]

another way to do this is to format the cell using the custom mode.

Format cell>number>custom in Type box enter
£##0.00;-£##0.00;
the last ";" is need to define how to display zero,

if you entered
£##0.00;-£##0.00;"nil"

this would print the word "nil" for zero values

Hope this helps

Mik

 

[Freemini]

See my reply in Andy B's post

another way to do this is to format the cell using the custom mode.

Format cell>number>custom in Type box enter
£##0.00;-£##0.00;
the last ";" is need to define how to display zero,

if you entered
£##0.00;-£##0.00;"nil"

this would print the word "nil" for zero values

Hope this helps

Mik

 

[Ken Wright]

And if you'd like to actually hide all those rows, then Select the range, do
Data / Filter / Autofilter, Click on the dropdown, hit Custom and then select
not equal to 0. You'd have to do this each time you updated your list though,
to be sure you were seeing all the valid rows.