LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Formula result not displaying in cell

I have entered a function:

=SUM(IF(ISBLANK(F3:F39),E3:E39,0))

This is supposed sum the values in E3:E39 where the corresponding cell
in F3:F39 is blank. When I open the formula editor box, the formula
result displays correctly, but the cell only displays 0. Any ideas?
Here's some sample data:

Withhold Amt. Released
$750.00
$200.00 2/3/2006
$300.00


Total Withholding: $1,050.00 (supposed to be)

The total withholding is displaying 0 in the cell but in the formula
editor dialog box the formula result is shown as the correct 1050.

Any ideas why the formula editor would show correct amount while the
cell only shows 0?

Thanks,
Brandon

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Showing In A Cell Instead of Proper Result DanK New Users to Excel 2 March 4th 06 06:46 AM
Currency to Text mytipi Excel Worksheet Functions 1 February 21st 06 11:43 PM
Text in formula bar is not displaying in cell Mike Excel Discussion (Misc queries) 0 August 29th 05 09:47 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
How do you copy a cell formula down a column without displaying n. Coddie Excel Worksheet Functions 4 January 18th 05 02:31 PM


All times are GMT +1. The time now is 01:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"