Kassie,

Thank you for your help. The solution fits perfectly.

Randy

"Kassie" wrote:

Hi rmoore

I do not know in which cells you have the problem, but for the sake of this
excercise, let's say Col A may contain text or numbers, and you want to
multiply with Col B, to get a result in Col C.

In say C2 insert the following formula:

=IF(ISTEXT(A1),"",B1*A1)

Adjust to suit your locations, and copy down

--
ve_2nd_at. Randburg, Gauteng, South Africa


"rmoore" wrote:

I am converting a Lotus 1-2-3 spreadsheet to Excel 2003 (SP3). Lotus allows
for text or numbers to be entered into a cell that is referenced in a formula
that calculated a price. If text is entered in the cell it looks as if Lotus
ignores it and the calculation is not executed.

If I try this with Excel, it executes the text and renders an error. Is
there a way to duplicate what Lotus is doing?