I have an invoice that I've created in Pages to send to customers - see attached image.
I would like to have all the $0.00's hidden when not needed as circled in red. I know there is a post in this forum that is almost the same as the one I'm writing now, but for some reason I'm not able to make that given information work on my end.
Thanks
iMac 27″ 5K, macOS 10.15
Two possibilities:
Set a Conditional formatting rule on all the cells in column E. The Custom rule shown in the right sidebar sets the text colour to 'white' if the value in the cell is 0.
The upper table and lower table contain the same values in column E. The bottom table has the rule shown applied to the selected cells.
OR
Add a 'switch' to the formula creating the value in column E to return a null string ( "" ) to its cell if either of the cells supplying its data is empty.
This is the top table, with no CH rule applied.
The formula shown in entered in E5 and filled down to the end of the column. Both time and rate have been entered in rows 2 and 3, so both expressions in OR return FALSE, making OR also return FALSE. IF calls the if-false part of the formula, and the product is calculated.
In Row 4, the rate has been entered in D3, but the hours have not been entered in C3. C3="" returns TRUE, so OR returns TRUE, and IF calls the if-true part and places a null string in its cell, giving it the appearance of being 'empty' as shown.
Pasteable version of th formula for E2: IF(OR(C2="",D2=""),"",C2×D2)
Regards,
Barry
Hi Barry,
Thanks for that great explanation....I ended up going with your first suggestion of changing the text to the background color which works beautifully. So grateful for your help. When I finally understand how stuff like this operates, it's a pleasure to use.
Best,
Peter
You're welcome, Peter.
Take some time to explore occasionally. And do continue to ask questions here when you're stuck!
Regards,
Barry
Pages formula without displaying $0.00
