Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

IF, AND - 3 Values - Forgotten How?

More
1 month 4 weeks ago - 1 month 4 weeks ago #1566 by Rajesh S.
Replied by Rajesh S. 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 month 4 weeks ago by Rajesh S..

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

More
2 months 3 weeks ago #1526 by simon
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.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoQiu hongkunJay Chivo