Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cel values help needed
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cel values help needed
something similar to
=IF(ISBLANK(A1),"",A1-A2) is probably what you're looking for. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Tim Turner" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cel values help needed
=IF(LEN(TRIM(H17))<1,"no","yes")
-- Don Guillett Microsoft MVP Excel SalesAid Software "Tim Turner" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cel values help needed
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. "Don Guillett" wrote: Clarification =IF(LEN(TRIM(H17))<1,"blank","notblank") -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message ... =IF(LEN(TRIM(H17))<1,"no","yes") -- Don Guillett Microsoft MVP Excel SalesAid Software "Tim Turner" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Avoiding negative values in IF statements help needed | Excel Worksheet Functions | |||
Help needed in updating excel worksheet values | Excel Worksheet Functions | |||
formula needed to bring values to another sheet | Excel Worksheet Functions | |||
formula help needed (if values) | Excel Discussion (Misc queries) | |||
Pivot chart - Ignore zero values - help needed | Excel Discussion (Misc queries) |