Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-19-2018, 11:24 AM
melvin1942 melvin1942 is offline Invioce:  Hide cost in column F Windows 10 Invioce:  Hide cost in column F Office 2007
Advanced Beginner
Invioce:  Hide cost in column F
 
Join Date: Apr 2016
Posts: 42
melvin1942 is on a distinguished road
Default Invioce: Hide cost in column F

Sirs is there a way to hide the total cost in column F until you enter a cost in column E?
The cells in Column F shows $0.00 If the cells in the column F shows $0.00 I do not want them shown any think until a price is entered in column E.

See the attached file.



Thank you for your time.

Melvin1942
Attached Files
File Type: xlsx New Life Tractor Co. Invioce.xlsx (81.4 KB, 9 views)
Reply With Quote
  #2  
Old 04-19-2018, 03:11 PM
NoSparks NoSparks is offline Invioce:  Hide cost in column F Windows 7 64bit Invioce:  Hide cost in column F Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

How about =IF(OR(B13="",E13=""),"",E13*B13) in F13 and drag down to F40 ?
Reply With Quote
  #3  
Old 04-20-2018, 07:01 AM
melvin1942 melvin1942 is offline Invioce:  Hide cost in column F Windows 10 Invioce:  Hide cost in column F Office 2007
Advanced Beginner
Invioce:  Hide cost in column F
 
Join Date: Apr 2016
Posts: 42
melvin1942 is on a distinguished road
Default

NoSparks, I thank you for your advise. It works real good.

Melvin1942
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Invioce:  Hide cost in column F Need to default the Cost Column based on another column's value ProjectCalcs Project 1 10-03-2016 07:02 AM
Which column shows just labor cost? ketanco Project 9 06-20-2012 02:19 PM
How to rename cost column ketanco Project 3 06-15-2012 03:06 PM
free slack changes when i paste from fixed cost to cost1 column ketanco Project 5 02-03-2012 06:17 AM
Hide Row and Column Headers mhlipp Excel 1 11-14-2011 05:10 AM

Other Forums: Access Forums

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


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