View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kristin Kristin is offline
external usenet poster
 
Posts: 43
Default 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?