Hi All
I have a formula that I need to examine a range of criteria using IF & AND to check results. I have several columns and can create multiple AND logical criteria but this takes a huge amount of time as there are over 30 columns, and will grow to many more.
The formula I would use and know works is:
=if(and(b1="No",b2="No"),"Not Started",In Progress")
b1 onwards could eventually reach in excess of b100. (RSI City)! )
What I though I would do is
=if(and(b1:b100="No"),"Not Started","In Progress")
but this always returns a #value! error.
Probably something simple but can't get the darn thing to work.
As always, thanks in advance for any help you can provide.
TexasKersh
Bookmarks