Path: utzoo!utgpu!news-server.csri.toronto.edu!bonnie.concordia.ca!uunet!shelby!agate!usenet.ins.cwru.edu!pyrite!bhatlas
From: bhatlas@pyrite.som.cwru.edu (Sunil Bhatla)
Newsgroups: comp.sys.mac.apps
Subject: Help a manual-weary WINGZ user!
Message-ID: <1991Feb25.022254.23689@usenet.ins.cwru.edu>
Date: 25 Feb 91 02:22:54 GMT
Sender: news@usenet.ins.cwru.edu
Organization: WSOM CSG, CWRU, Cleve. OH
Lines: 20
X-Post-Machine: pyrite.som.cwru.edu
Nntp-Posting-Host: pyrite.som.cwru.edu


How do I get WingZ to return a user-specified value (say 8.75) if it
finds a text string (say B+) in a given cell? The IF(condition,x,y)
function specified in the manual only handles numbers, not text
strings.

My problem is that I have a bunch of letter grades that I need to
compute averages for. Any ideas will be appreciated (yes, I know there
are programs out there that will do just this, but I would rather
stick with WingZ - if Lotus 123 can do it, why can't WingZ!).

Thanks in advance,

Sunil.
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sunil Bhatla                      |||  INTERNET: bhatlas@pyrite.som.cwru.edu
Case Western Reserve University   |||     VOICE: 216/368-2061
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~