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

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
---
"RYNNER" wrote:
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 forth at C row.. and what if A1
is blank then A2 has a value and i wanted it to automatically formulated at
C1.

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"RYNNER" wrote:

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