Olly - profile

Olly · Sep 17, 2019

Hi, I have the following formula that works by displaying a ! when col1 is empty: IF({Col1} = BLANK(), “!”, “”) However I would like to add OR statement so that the ! is displayed if either Col1, Col2 or Col3 have no entries. I have tried varying di...

Olly · Sep 17, 2019

Thanks Claudio, Used your formula to come up with following that works for me: IF(OR(Col1,Col2,Col3),"", “!”) Thanks again Olly

User Statistics

User Activity

Blank() with OR formula

Re: Blank() with OR formula