Home |
Search |
Today's Posts |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#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!! |