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 in Others by Kithuzzz
• 20,660 points
30 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 by narikkadan
• 37,660 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 in Others by Edureka
• 13,640 points
101 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 in Others by narikkadan
• 37,660 points
37 views
0 votes
1 answer

Return empty cell from formula in Excel

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

answered Nov 20 in Others by narikkadan
• 37,660 points
20 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 in Others by narikkadan
• 37,660 points
35 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 in Mobile Development by narikkadan
• 37,660 points
26 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 in Others by Edureka
• 13,640 points
137 views
0 votes
1 answer

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

Hi To Calculate the date, we can ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
230 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 in Others by narikkadan
• 37,660 points
41 views
0 votes
1 answer
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