Follow Up On Previous Post - Specific Identity Unknown

Column Z has a drop down box which offers choices for the identification of types of funds collected. C for Cash, CK for Check and CR for Credit.

This was done in the past with looking at X10 - "Calculated Cost of Stay" and placing it in the proper spot with =if(X10="C",X10,""). Now with Y10 - "Actual Paid" needing to be looked at and characterized as well, what to do?

Cash = AA
Check = AB
Credit = AC

Thanks,

Mel

Sorry, if your drop-down was in Z10 then surely your formula was:

=if(Z10="C",X10,"")

If so, and if only X10 or Y10 will have a value in then:

=IF(Z10="C",MAX(X10,Y10),"")

Right on both comments, thanks for the help. Hopefully I'm getting to the endpoint of this thing. As I'm sure you are aware as I get closer to what I thikg is the end more minute things pop up.

Thanks again.

Mel