R. VENKATARAMAN
 

when summing up in H21-- A21*G21 and there is no entry for G that row I'm
getting a #Value! error, can I change somethink so its blank rather than
Value (which will interefere with the total)

=IF(G21="",0,A21*G21)

Regards

Trevor


"Jaladino" wrote in message
...
when summing up in H21-- A21*G21 and there is no entry for G that row I'm
getting a #Value! error, can I change somethink so its blank rather than
Value (which will interefere with the total)

Just change the value_if_true in the error trap formula
to return a zero: 0 instead of ""
i.e. try instead in C21:

=IF(ISNA(MATCH($B21,$J$21:$J$37,0)),0,VLOOKUP($B21 ,$J$21:$L$37,COLUMNS($A$1:
A1)+1,FALSE))

or use SUM(... ), e.g.: =SUM(A1:A2) instead of : =A1+A2
(SUM will ignore text)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Jaladino" wrote in message
...
when summing up in H21-- A21*G21 and there is no entry for G that row I'm
getting a #Value! error, can I change somethink so its blank rather than
Value (which will interefere with the total)