correct syntax for and "if statement"

Posted by Sheila on February 06, 2002 6:46 AM

This was simple in LOTUS...
In an if statement I want the condition to be a range of numbers such as =if(B5=>20&B5=&LT;29,"Yes","No"). Does anybody know the correct syntax to identify the range 20 to 29, inclusively?

Greatly Appreciated!!

Posted by Steve Hartman on February 06, 2002 6:50 AM

=IF(AND(B5=>20,B5=< 29),"Yes","No")

=IF(AND(B5=>20,B5=&LT; 29),"Yes","No")

Posted by MattR on February 07, 2002 3:19 AM

Re: adding an unknown range

I checked out the help file for "Running Total".
Try this
Collum C
C2 should equal the starting value i.e 100.00 then
C3 enter: =SUM(C2,B3) (and copy down)

B3 is where you enter the deposit value
Then to divide the value in C3 by 2
=C3/2
and copy down...

Let me know if this works.
Cheers
Matt