IF function based on a Countif result

mtaylor

Board Regular
Joined
May 1, 2013
Messages
51
Platform
  1. Windows
  2. MacOS
Hi Team,

This should be an easy one, I just can't seem to finish it off.

I want to count the number of TRUE values across 4 consecutive cells, and based on that number, if it is greater than 1, a P appears, if not a UA appears.

I'm currently using this:

=IF((COUNTIF(C3:F3,TRUE)>1),P,UA)

But I get the error occurring.

Many thanks in advance

Matt
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,526
Office Version
  1. 365
Platform
  1. Windows
Does this resolve the issue?

Excel Formula:
=IF((COUNTIF(C3:F3,TRUE)>1),"P","UA")
 
Solution

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,526
Office Version
  1. 365
Platform
  1. Windows
You're welcome. Thanks for the follow-up. :)
 

Watch MrExcel Video

Forum statistics

Threads
1,119,183
Messages
5,576,574
Members
412,734
Latest member
rubinrods
Top