Replace cell info help

[Seldar]

I am trying to make a sheet with replace values on it, for example if
put a value of 18 into A1 it changes the value in b2 it is not a mat
function so i do not know where to start. it is a just a easy numbe
replacement, what i really need to do is have a a value of 3 to 18 ma
and then that would change the value of another slot.

Example;
if a1=3 then b1=35
if a1=4 then b1=45
if a1=18 then b1=225

thats what i need to do but have no idea how to do it, any help woul
be great.

Simo

 

[Frank Kabel]

Hi
enter the following formula in B1
=IF(A1=3,35,IF(A1=4,45,IF(A1=18,225,"")))

 

[Seldar]

thanks alot, your help is greatly apreciated

 

[James]

Note that you can use "ALT-Enter" to have multi-line formulas to clean
up nested IF statements: for example

= IF( A1 = 3 , 35,
IF( A1 = 4 , 45,
IF( A1 = 18, 225, 0
)
)
)
To get the new lines, just enter "Alt-Enter"

-james

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***