| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I get a function formula cell to format as a number?
I put this formula "=IF(OR($C$9="Check",$C$9="Decrease
Adjustment"),$G$8,"0")" and the cell formats as a number but when I put this formula "=(IF($C$8="Enter Transaction",IF(OR($C$9="Withdrawal",$C$9="Increas e Adjustment"),$G$8,""),""))&(IF($C$8="Enter Receipt",IF(OR($C$9="Check",$C$9="Decrease Adjustment"),$G$8,""),""))" it doesn't. I have gone into the fomatting of the cell and it shows that it should be viewing appropriately but it is not doing it. Can someone tell me what I am not doing in order to get the second function formula to show as as number? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function for euro number format? | Excel Worksheet Functions | |||
| Format Cell formula vs number | Excel Discussion (Misc queries) | |||
| Number format using TEXT( ) function | Excel Worksheet Functions | |||
| function to count the number of cell references in a formula | Excel Worksheet Functions | |||
| Setting Cell Number Format With A Worksheet Function | Excel Worksheet Functions | |||
Threaded Mode
