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