replace cell with formula

Posted by Andonny on December 15, 2000 4:13 PM

Hi again,
I need to replace cell E1 with (B1*0.35). The problem I am having is that I don't know in which row "SOFTDRINKS" will be. Every time I get the report it will be at a different row. It will always be in column A.

Maybe somebody kind can give me advice on this

A B C D E F G
1 SOFTDRINKS (11) (110) 15 LIME LEMON 0 5.00 65.00

Thanks a lot
Andonny

Posted by Aladin Akyurek on December 27, 2000 5:08 AM

Why not use an additional column (e.g., H) where you can put in H1

=IF(a1="SOFTDRINKS", B1*0.35,E1)

and copy it down as far as needed? Wouldn't this work?

Aladin