Thread: #VALUE!
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default #VALUE!

Welcome. The =IF(COUNT(G2:G3)<2,"", ... trap simply ensures that G2:G3
contain numbers before proceeding with the arithmetics between them. This
averts the #VALUE error which would result if G2:G3 were to contain text
such as null strings: "", returned by formulas
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"nso" wrote in message
...
i dont understand it but that worked, thanks!!