View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
DavidB DavidB is offline
external usenet poster
 
Posts: 41
Default How do I string formulas together in Excel to display variables

I want to display a range of quotes in one cell from a formula in that
cell...if you can make sense of that. The first part of the formula works
well and displays one of five messages but I cant add any more formulas to
the existing one without getting error messages, for example:
=IF(AND(B1384,B13<101),"High Distinction"). This works well but I need to
add more to it in order to display Distiction, Credit, NGP, Fail...I am more
than willing to send to anyone who can help me, the Excel spreadsheet to have
a look at.
Cheers
David