View Single Post
  #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