[mso] Re: Excel Formula

  • From: Wilson Baptista Junior <wilson@xxxxxxxxxx>
  • To: mso@xxxxxxxxxxxxx
  • Date: Mon, 22 Apr 2002 11:03:15 -0300

Try
         =IF(ISBLANK(F2),0,3-F2)
Wilson

At 18:51 21/04/02 -0500, Rick Silversmet wrote

>    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
>*************************************************************


*************************************************************
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: