I want to check if a range of 16 cells has a value greater than one, I want to use one cell to do this, do I need a macro or can it be done with a function?
I want to check if a range of 16 cells has a value greater than one, I want to use one cell to do this, do I need a macro or can it be done with a function?
Last edited by caliskier; 02-20-2012 at 05:46 PM.
Sorry, I answered my own question, using the blank cells off to the right I can use the formula =if(D1>$A$1,1,0) then use another cell to sum all those, if the answer <>0 then I have my check.
Hi Caliskier,
You should also be able to use:
=COUNTIF(A1:A16,">1")
If that returns any number greater than 0 it means you have a value greater than 1 in the range.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks