conditional statement problem

[RYNNER]

hello,

i hav a prob... how can i make a formula that states.. if A1=2 then B1+2
else B1+3(this is on cell C1) and so on and so fort at C row.. and what if A1
is blank then A2 has a value and i wanted it to automatically formulated at
C1.

hope you help me guyz...

rynner from philippines

 

[Max]

One guess, maybe you meant
In C1: =IF(A1=2,B1+2,B1+1)
then C1 is copied down

The above translates your specs:

if A1=2 then B1+2 else B1+3(this is in cell C1)

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---

 

[Shane Devenshire]

Hi,

Try

=B1+IF(A1=2,2,3)

or an even shorter version

=2+B1+(A1<>2)


And copy it down as far as needed.