I need to write a formula where if a range of cells all are marked with an x then the cell autopopulates "x", if only some are marked, then "In Review", and if nothing then nothing.
I currently have
=IF(AND(c8:c15="x"),"x","Review"))
With ctrl shift delete
How can I have this cell be blank if none of the cells in the cell range are marked?
Thanks for any help sorting this out!
I'm not sure if I need to use an array, but that is the only way I can get it to work.
Try:
=IF(COUNTA(C8:C15)=8,"X",IF(COUNTA(C8:C15)=0,"","In Review"))
Hope that helps.
-Z
Thank you Zodeeak!!!!! Worked perfect - and such a fast response!
One more question though -- what if the number of cells in the cell range may vary? Is there a way to automatically adjust?
There are always ways...
You could have a cell set up to designate how many to count down (say cell C2) and use the formula like this:
=IF(COUNTA(C8:C50)=C2,"X",IF(COUNTA(C8:C50)=0,"","In Review"))
or
=IF(COUNTIF(C8:C50,"x")=0,"",IF(COUNTIF(C8:C50)>=C2,"X","In Review"))
Hope that helps.
-Z
Last edited by Zodeeak; 11-17-2014 at 02:28 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks