Thread: Average letters
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
superkopite
 
Posts: n/a
Default 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