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, 16 views)
Reply With Quote
  #2  
Old 03-25-2010, 11:37 PM
Matrix's Avatar
Matrix Matrix is online now Formula and Table Help! Windows XP Formula and Table Help! Office 2003
Admin
 
Join Date: Jan 2005
Posts: 429
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



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 12:11 AM.


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