IF, AND - 3 Values - Forgotten How?

By bugle on Wednesday, 27 March 2019

Posted in Excel

Replies 1

Likes 0

Views 6.6K

Votes 0

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