LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Mifty Jackson
 
Posts: n/a
Default Formulas returning a blank if no data entered in one cell

Hi,
Very new to all this! I want to set up cells showing a percentage
difference. I've figured out how to get it to do that but want to have a
blank cell if no data has been entered into one of the other cells i.e price
before increase = A, price after increase = B and C = % diff. If I don't
enter a value in B how can I make sure C is blank?
Also would you recommend keeping formulas in a separate part of the
worksheet and returning the answer to C. If so how would I do that.
Sorry this is a bit rambly
--
Mifty
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Changes when data entered in referenced range mac849 Excel Discussion (Misc queries) 5 March 21st 05 01:57 AM
REPOST: How can I make the graph omit blank cells in the data set? easy Charts and Charting in Excel 2 March 17th 05 09:57 AM
eliminate data entered to a worksheet that copies to another work. flaguilar Excel Worksheet Functions 2 March 14th 05 05:20 PM
Formulas (If linked data is not null, then insert "Complete" in ce Task Lead Nicole Excel Worksheet Functions 3 January 10th 05 06:25 PM
Formulas in source data Ken Charts and Charting in Excel 3 December 1st 04 05:43 PM


All times are GMT +1. The time now is 10:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"