Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-25-2010, 09:04 PM
steveman1234 steveman1234 is offline Formula and Table Help! Windows Vista Formula and Table Help! Office 2007
Novice
Formula and Table Help!
 
Join Date: Mar 2010
Posts: 22
steveman1234 is on a distinguished road
Default Formula and Table Help!

I have a table set up (with formulas) regarding an invoice. I have a end row of totals which leads into the subtotal box. However, when there is nothing in a row, the total still ends up as "$0.00" (without the quotes). What can I do so that there is just a blank space instead of this? Thank you for help in advance.



-Steven
Attached Images
File Type: jpg Table with zeros.JPG (54.6 KB, 7 views)
Reply With Quote
  #2  
Old 03-25-2010, 11:37 PM
Matrix's Avatar
Matrix Matrix is offline Formula and Table Help! Windows XP Formula and Table Help! Office 2003
Admin
 
Join Date: Jan 2005
Posts: 396
Matrix is on a distinguished road
Default

This link should help.
Reply With Quote
  #3  
Old 03-28-2010, 06:20 PM
steveman1234 steveman1234 is offline Formula and Table Help! Windows Vista Formula and Table Help! Office 2007
Novice
Formula and Table Help!
 
Join Date: Mar 2010
Posts: 22
steveman1234 is on a distinguished road
Default Thanks!!

thanks so much! that is EXACTLY what I was looking for!!
Reply With Quote
Reply

Tags
formulas, table, zeros

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula and Table Help! Help with Formula Corca Excel 6 02-22-2010 09:40 PM
Formula and Table Help! If formula sixhobbits Excel 1 10-02-2009 08:02 AM
Help with Word table formula fritman99 Word Tables 1 09-02-2009 05:36 PM
Help for formula dehann Excel 5 05-01-2009 10:44 AM
Formula and Table Help! Need help with a formula tinkertron Excel 11 04-16-2009 11:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft