HELP WITH THE IF FUNCTION

K

KAL at home

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?
 
D

Dave F

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.
 
R

RagDyer

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top