Average letters
 

hiya guys,

I need some help. in my worksheet cells B1 to B13 contain either an "r"
or a "g" i need cell b14 to display an "g" if 75% of the cells B1:B13
contain a "g" if not it should display an "R".

I am a noob and have no idea how to do this but have to get it done for
work 2moro!!!

Cheers

James


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=491944

Average letters
 

Countif can tell you how many cells in a range meet a certain condition. So
you could do something like
=if(countif(b1:b13,"g")=3*countif(b1:b13,"r"),"g" ,"r")

"superkopite" wrote:


hiya guys,

I need some help. in my worksheet cells B1 to B13 contain either an "r"
or a "g" i need cell b14 to display an "g" if 75% of the cells B1:B13
contain a "g" if not it should display an "R".

I am a noob and have no idea how to do this but have to get it done for
work 2moro!!!

Cheers

James


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=491944

Average letters
 

Thanks alot that worked a treat.


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=491944