Log in  \/ 
x
or
x
x
Register  \/ 
x

or

normal IF, AND - 3 Values - Forgotten How?

More
1 year 1 month ago - 1 year 1 month ago #1566 by Raj2018
Replied by Raj2018 on topic IF, AND - 3 Values - Forgotten How?
You may use this Formula:
=IF(ISBLANK(A1),"",IF(AND(A1="X",A2="Y"),1.5,1))
Last edit: 1 year 1 month ago by Raj2018.

Please Log in or Create an account to join the conversation.

More
1 year 2 months ago #1526 by bugle
Hi
Newbie here.
I have forgotten the syntax for the following formula e.g.
If A1 = x, "1"
If A1 = x AND A2 = y, "1.5"
If A1 = "", ""

Many thanks

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun