HELP WITH THE IF FUNCTION
 

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?

HELP WITH THE IF FUNCTION
 

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?

HELP WITH THE IF FUNCTION
 

If your data is in Column A, and you mention 'currency values', are there
any other *type* of values possible in A1, or will it just be blank or 0?

Try this:

=IF(OR(A1={"",0}),"",A1)

And copy down as needed.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"KAL at home" <KAL at wrote in message
...
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?