help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do you either hide the values of formulas in cells until the formula is
calculated? Let me explain, i have done a simple calculation (=J5-4) however
this results in the value of -4 until a new value is enetred. How do you
stop it from calculating the result straight away (or when the current value
is blank / zero)

or secondly how can you hide negative values in cells?

if you can assit that would be appreciated

Justin
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Returning Multiple Results with Vlookup 1
Calculate After hours 3
nested IF(OR Vlookup returning zero instead of value in target cel 7
How do I limit formula results to positive only? 4
Need blank cells to remain empty 7
Calculations 1
Hiding Formula Answers in Specific Cells 1

Back
Top