Multiple conditions

[Dave Hill 1974]

Hi All, New user!!

Trying to put an if statement in and have two conditions and a blank.

ie. If cell = 34 do A, if cell = 38 do B otherwise do nothing.

Have looked into Case / Else statements but only seem to be able to do these in VBA and not suitable for my needs.

Any help greatly appreciated.

Version using (Unfortunately at work) is 2000 but have 2007 at home.

Cheers,

Dave.

[stevekirk]

hi dave

welcome to the forum

try this

=IF(A1=34,50,IF(A1=38,100,""))

steve

[Dave Hill 1974]

Cheers Steve,

Hope I can be of help back someday.

Dave.