Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |