SteveG Wrote:
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

back to this one: i have 6 numbers 1-6 each needs a word - one-six lets
make it
now i understand how to make the IF but how to make a couple fof IF's
in one FUnction! Again Thanx!!


--
nerdman
------------------------------------------------------------------------
nerdman's Profile: http://www.excelforum.com/member.php...o&userid=29614
View this thread: http://www.excelforum.com/showthread...hreadid=493420