If statements

carley465 · #1 (**permalink**) 03-02-04, 10:06

In Excel can you do an "If" statement. Such as" if B1>50 then B1*4, Else B1*5.

CAT

goodthing44 · #2 (**permalink**) 03-02-04, 21:53

NO. follow this if(b>1,a+b,b+c)

DavidCoutts · #3 (**permalink**) 03-03-04, 06:00

HI

Sorry about the other post did it to quickly I just tried to get rid of the error message for you without checking to hard.

The only way i can think of doing this is by using VBA if you actually wawnt the Value of B1 to change.

Something like this

Code:

If Range("B1").Value > 50 Then
    Range("B1").Formula = Range("B1").Value * 4
Else
    Range("B1").Formula = Range("B1").Value * 5
End If

or if you want to run the if statement in any other cell you can just use the formula

=IF(B1>50,B1*4,B1*5)

Ive tried both of these methods and they both produce the correct results.

David

Internet Services

Web Development

Digital Marketing

Consumer Tech