[mso] Excel Formula

  • From: "Rick Silversmet" <Union865@xxxxxxxxxxxx>
  • To: <mso@xxxxxxxxxxxxx>, <ms_excel@xxxxxxxxxxxxxxx>
  • Date: Sun, 21 Apr 2002 18:51:15 -0500

   I need help with a formula. What I want to occur is this: if cell f2 is
blank, then I want cell g2 to give me an answer of zero. If, a zero, 1, 2 or
3 is entered into cell f2, then I want the answer in cell g2 to subtract
that number from the number 3. This is the formula that works in Quatro Pro,
but won't work in Excel. I'm using Excel 2K.

=IF(F2=0,3,IF(F2>0,(3-F2),0))

Thanks for any and all help with my problem.

Rick

|^^ ^^^^^^^^^^^^| ||____
|       B u d w e i s e r  | ||'|"\,__
|_..._...______===|=||_|__|...,]
 "(@)'(@)"""*|(@)(@)*****(@)*I

Keep the rubber side down......


*************************************************************
PLEASE READ!!!!

This is not S*P*A*M!  You are receiving this mail because you either subscribed 
to mso@xxxxxxxxxxxxx or to it's earlier version, 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with 
a subject line that says "unsubscribe" (without the quotes).  Do not put 
unsubscribe IN CAPS.  Screaming doesn't get you out any faster and the caps 
prevent the function from working.

To change your email settings to digest or vacation (no mail), visit the 
group's homepage for full instructions.

//www.freelists.org/webpage/mso
*************************************************************

Other related posts: