disregard a cell on occasion when there is text in it instead
hi
that did the job
Thank you very much
"CLR" wrote:
This is kinda brute force, but should do the job..........
=IF(ISNUMBER(C8),C8*C$6,0)+IF(ISNUMBER(D8),D8*D$6, 0)+IF(ISNUMBER(E8),E8*E$6,0)+IF(ISNUMBER(F8),F8*F$ 6,0)
All on one line, watch out for word-wrap when copying..........
hth
Vaya con Dios,
Chuck, CABGx3
"Gilles St-Amour" wrote:
Hi
in the following simple formula =(C8*C$6)+(D8*$D$6)+(E8*$E$6)+(F8*$F$6)
sometime the value in the cell c8 or d8 or e8 or f8 is actually a letter(
because of a special requirement), of course I get en error when that happen.
I do not want to remove the cell from the formula everytime because I will
input number sometime in that cell.
I looking to keep the same formulas but with something to disregard the
text value when required or take the number value when there is one in the
cell.
So that way I can copy the formula whitout having the worry about editing
everytime
Thanks in advanced
Gilles
|