I believe you would have to create a user defined function which tests for
the cell's formatting.

Something akin to =if([format is currency],[action 1],[action 2]).

Excel's built in functions don't test for cell formats.


--
Brevity is the soul of wit.


"KAL at home" wrote:

I have a range of cells that may or may not have a currency figure in them if
a cell in the range has currency figure I want the figure placed into another
cell, ie. A column has an expenses listed and then they need to be itemized
below. Isthere an IF function which will do that?