Formula help

A

Aaron Neunz

I have a range of cells E10:E20. There is going to be a dollar amount in
only one cell of that range. Can someone help me with a formula that will
scan the range of cells and return the dollar amount (wherever it may be)?

Thanks,
Aaron Neunz
 
B

Bernard Liengme

What will be in the other cells?
Text, numbers not formatted to $, ?????
tell us more and we'll try to help
 
Top