Thread: Help with Averages/Sums of values returned from IF function
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Help with Averages/Sums of values returned from IF function
Are you sure that you want text strings as the results of your formula? If
you want numbers, throw away the quote marks.
--
David Biddulph

"TheBigUnit622" wrote in message
...
Thanks for your help so far, Bernard. Seems like you know what I'm trying
to
accomplish. One of the IF statements follows (Stats and Points is another
sheet in the workbook).

=IF('Stats and Points'!F2=60, "2", IF('Stats and Points'!F2<=44.9, "0",
"1"))


Reply With QuoteReply With Quote