I have formulas in fields that are like this =IF(AND(EB7-C7<30,EB7<""),"x","")
but I want it to use an E if a cell has an "X" and a D if a different cel
has an "X" but they need the current formula to work with these so at the end
of my worksheet I can tally how many E's and D's for each specific time
period. There are other columns with <60, <90, <180, etc.. These are used for
monthly statistical reports.

Thanks
--
Celeste

Celeste,

Can you give an example of what the data looks like, where it is stored
etc., and what your expected result is?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Celeste" wrote in message
...
I have formulas in fields that are like this
=IF(AND(EB7-C7<30,EB7<""),"x","")
but I want it to use an E if a cell has an "X" and a D if a different cel
has an "X" but they need the current formula to work with these so at the
end
of my worksheet I can tally how many E's and D's for each specific time
period. There are other columns with <60, <90, <180, etc.. These are used
for
monthly statistical reports.

Thanks
--
Celeste