Cel values help needed

T

Tim Turner

i have a spreadsheet to compare inputed predicted and actual values (football
scores that are predicted against actual results) and return a score. Excel
appears to treat an empty cell as a zero value, how can an empty cell be
flagged as "empty" and prevent the calclation taking place untill a value is
entered.

Any help gratefully accepted
 
T

Tim Turner

Don,
Thanks for the info, have worked this into a solution. It has also led me to
the COUNTBLANK function which is very useful for returning a value if a cell
is empty or has an input. This value can then be used as a logic value for
comparison.
 

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

Top