Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
Your time
Thursday, —: —: —
Our time
Thursday, 07: 53: 14
New

IF, AND - 3 Values - Forgotten How?

  Excel
bugle
  bugle
  Wednesday, 27 March 2019
  1 Replies
  6.6K Visits
0
Votes
Undo
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
0
Oldest First  
Raj2018
Raj2018
5 years ago
·
#1896
0
Votes
Undo
You may use this Formula:

=IF(ISBLANK(A1),"",IF(AND(A1="X",A2="Y"),1.5,1))
  • Page :
  • 1
There are no replies made for this post yet.