Thread: How do I format list of names formatted last,first to first last?
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG
 
Posts: n/a
Default How do I format list of names formatted last,first to first last?

To round your average.

=ROUND(AVERAGE(P1:P26),0) - Wher P1:P26 are your numbers to average.

To return a Yes in cell B1 if the value in say cell A1 is = 5 then in
B1

=IF(A1=5,"Yes","")


Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=493420

Reply With QuoteReply With Quote