Ask Your Question
0

if and if statements

asked 2019-06-12 21:48:40 +0200

briansmith gravatar image

Trying to create a formula where two or more arguments are required. For example Cell A1 contains 1 Cell A2 contains Y Cell A3 contains 290

Formula wanted - IF Cell A1 is 1 and Cell A2 is Y and Cell A3 is less than 300 then do something (1) or do something else (2).

I can work with the 1 and 2 (the things to do) but having a problem with the IF Statement

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-06-12 22:32:56 +0200

Opaque gravatar image

updated 2019-06-12 22:33:23 +0200

Hello,

=IF(AND(A1=1,A2="Y",A3<300),do_something(1),do_something_else(2))

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-06-12 21:48:40 +0200

Seen: 27 times

Last updated: Jun 12