home *** CD-ROM | disk | FTP | other *** search
/ NetNews Usenet Archive 1992 #26 / NN_1992_26.iso / spool / comp / os / mswindo / misc / 4469 < prev    next >
Encoding:
Internet Message Format  |  1992-11-09  |  1.5 KB
  1. Path: sparky!uunet!noc.near.net!hri.com!spool.mu.edu!sdd.hp.com!zaphod.mps.ohio-state.edu!sol.ctr.columbia.edu!eff!iWarp.intel.com|ichips!sc9!bhouser
  2. From: bhouser@sc9.intel.com (Brad Houser)
  3. Newsgroups: comp.os.ms-windows.misc
  4. Subject: Re: Excel 3.0
  5. Message-ID: <1992Nov10.003640.1842@ichips.intel.com>
  6. Date: 10 Nov 92 00:36:40 GMT
  7. References: <1992Nov8.232913.6235@gw.wmich.edu>
  8. Sender: news@ichips.intel.com (News Account)
  9. Reply-To: bhouser@sc9.intel.com
  10. Organization: Intel Corporation, California Technology Development
  11. Lines: 31
  12.  
  13.  
  14. In article <1992Nov8.232913.6235@gw.wmich.edu>, x89cole12@gw.wmich.edu writes:
  15. >I am using MicroSoft Excel V3.0.  I am having difficulty with the IF function.
  16. >I want to check if one cell is less than the other and print a 'Y' or 'N'
  17. >in the current cell if it is.  Can anyone help me?
  18. >For example:
  19. >
  20. >    A        B        C
  21. >-------- -------- --------
  22. >     500     1000     Y     If (A<B) then Y
  23. >    1000      500     N              ELSE N
  24. >
  25. >Exactly how do I do this?  I can get a logical true/false value.  However, I 
  26. >don't know how to insert a 'Y' or 'N'.  I thought about using a lookup table.
  27. >Would that be a good solution.  
  28. >
  29. >Help me in KALAMAZOO!!!!
  30.  
  31. Use the formula:
  32.  
  33.     =IF(A3<B3,"Y","N")
  34.     
  35.  
  36. >
  37. >Jason Cole            X89COLE12
  38. >
  39. >
  40. --
  41. [Brad Houser                               <This space for rent>     ]
  42. [                            bhouser@sc9.intel.com                   ]
  43. [+1-408-765-0494                                                Woof!]
  44.