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.