Welcome!

IF and OR Formula

Hi,

I am trying to write a formula that returns a flag if one of column 1,2,3,4,5,6,7 isn't checked. I have tried using the IF and OR formula together but am getting #Unparseable.

Any ideas/help will be appreciated.

Thanks

Find more posts tagged with

Education

Formulas

Project Management

Comments

Alejandra

Hi bukolatadio,

Try using something like this:

=IF(OR([Column1]@row = 0, [Column2]@row = 0, [Column3]@row = 0, [Column4]@row = 0, [Column5]@row = 0, [Column6]@row = 0), 1, 0)

bukolatadio

Thanks Alejandra, will try this and let you know how it goes.

bukolatadio

Thanks Alejandra,

I have had to add some other conditions to this and modify it and I was able to get through.

Sign in to join the conversation!

Quick Links

Trending discussions

Adding sequetial number string
Hello I could use some help with this one. I got the formula to work in the "number column"…. but I cant currently get it to work as a column formula. Basically what I am trying to achieve is have it add a number in order if the "footer comp" column is unchecked. and miss is unchecked Right now it is counting but in the…
Average with exceptions
I'm need to apply a function to average a column (answer is correct (8)) if the other column (The nurse is caring for a a patient who dove into a) is NOT blank. I copied this over from an excel spreadsheet. I would like to keep the average in the top row. Right now it's saying "#unparseable" as the formula is not the same…
Need help with INDEX COLLECT Formula
This discussion was created from comments split from: How do I combine multiple INDEX Collect formulas in one Formular?.