Excel Formula - if values in columns all contain X then return

0 votes
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 by Kithuzzz
• 27,940 points
89 views

1 answer to this question.

0 votes

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 narikkadan
• 51,600 points

Related Questions In Others

0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

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

Feb 17, 2022 in Others by Edureka
• 13,640 points
168 views
0 votes
1 answer
0 votes
1 answer

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

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

answered Nov 12, 2022 in Others by narikkadan
• 51,600 points
104 views
0 votes
1 answer

Return empty cell from formula in Excel

There is no way to do this ...READ MORE

answered Nov 20, 2022 in Others by narikkadan
• 51,600 points
141 views
0 votes
1 answer

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

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

answered Nov 7, 2022 in Others by narikkadan
• 51,600 points
83 views
0 votes
1 answer

Multiple IF statements in Excel not working

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

answered Nov 12, 2022 in Mobile Development by narikkadan
• 51,600 points
50 views
0 votes
1 answer

IfError with else, does this function exist in Excel?

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

answered Dec 23, 2022 in Others by narikkadan
• 51,600 points
49 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,640 points
206 views
0 votes
1 answer

Excel - add all X in column and then multiply

Use countif for the count then multiply ...READ MORE

answered Oct 1, 2022 in Others by narikkadan
• 51,600 points
75 views
0 votes
1 answer

Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 51,600 points
185 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP