I need to perform a calculation on a cell, that is dependant on the
text value in another cell.

Its easy to do as part of visual basic. But can do the same as part
of a cell calculation ??

Something like,

If cell A1 = "abc" then cell A2 = cell a12 * 1.05

Try the following in cell A2.

=IF(A1="abc",A12*1.05,FALSE)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"hamstring" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I need to perform a calculation on a cell, that is dependant on
>the
> text value in another cell.
>
> Its easy to do as part of visual basic. But can do the same as
> part
> of a cell calculation ??
>
> Something like,
>
> If cell A1 = "abc" then cell A2 = cell a12 * 1.05

Many thanks - works a treat

>Try the following in cell A2.
>
>=IF(A1="abc",A12*1.05,FALSE)