Login Page - Create Account

Support Board


Date/Time: Sun, 19 May 2024 02:34:39 +0000



Post From: Having 2 =IF arguments with outcome =

[2018-03-29 09:56:39]
User651753 - Posts: 77
I have Colum P with data from RED OR GREEN

For the life of me, I cant code if there is a 2 true arguments
P3 =RED
P4= Red
P5 = GREEN

I am trying to use 2 arguments are true = "BUY" .,
=IF(P3="RED",IF(P4="RED","BUY"),"DO NOTHING")

If I use =AND it work and name the cell = 1
=AND(P3="RED",P4="RED") <CELL = 1 >