"becky" wrote...
. . . Do you know how to write the Excel
version of this formula? Please help if you can.
....
I do not understand this Lotus formula =AND(A9=$AA$2,A9<=$AB$2) in
cell AC2.
....

If you need 1s and 0s, change this particular formula to

=--AND(A9=$AA$2,A9<=$AB$2)

Unlike 123, Excel includes True and False values along with numbers, text
and errors. They can be converted to numeric 1 and 0 by applying any
do-nothing arithmetic operator like +0, *1 or double unary minus
[-(-(x))=-(-x)=x].