In an excel formula, columns A, B, and C check values and, if true, return "OK." Column D is where I want to see whether all three columns contain "OK," in which case I want to return text. I've tried other formulas, including converting OK to blank and utilising the ISBLANK formula, but they haven't been successful. Is anyone willing to offer advice?

The formula in A,B C is =IF(A2 = "Cell Site Change - Implementers","OK","Missing Site Change IMP")
Nov 3, 2022 in Others 1,317 views

## 1 answer to this question.

You can use the AND function:

```= IF(AND(A3="OK";B3="OK";C3="OK");"everything is great";"something is missing")
```

Where A, B, and C are in A3, B3, and C3 respectively.

answered Nov 4, 2022 by
• 63,720 points

## How to divide data in excel into 4 columns whose sum is almost equal to 1/4 of the sum of all values/

5049 is the sum of all numbers, ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## Is there a way to use LOOKUP/VLOOKUP/HLOOKUP to return headers in EXCEL. Current formula returning wrong value

Try this: =SUMPRODUCT(--(Schedule!\$B\$3:\$F\$7=A3)) READ MORE

## Determine if calculation between 2 date time values is < 72 Hours in excel

Actually, Excel is quite accommodating in this ...READ MORE

## (Excel) If cell is greater than <condition> then minus <number>

The IF function to calculate B5 (amount ...READ MORE

## Multiple IF statements in Excel not working

When you add an IF statement to a formula ...READ MORE

## IfError with else, does this function exist in Excel?

Next to IFERROR(), there also is the ISERROR() function, which ...READ MORE

## IF statement for a tax sheet does not work

Use vlookup() as that is much easier ...READ MORE