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: 1
Default Mult formula cell displays "0", which formula created result?

I am using the same formula format in 64 cells, they all return the correct
results except for one. The format is identical, refferanced cells are
correct in ID and contents.

There is no explination why the results are different in this one instance,
I would like to see which of the eight "IF" formulas in the cell is coming up
true and therefore displaying this result so I can further trace possible
causes, but I can not find a way for the active formula it to show itself by
becoming highlighted (or something).
 
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
need to substitute formula result from #### to"CHECK YOUR ENTRY" Trevor Excel Discussion (Misc queries) 2 June 13th 07 12:35 AM
formula bar displays "=RC[-12]+RC[-11]". how to get normal view? Laurent Excel Worksheet Functions 3 February 14th 07 09:59 AM
If result of formula is "" (Blank) why is this considered a num. Frank Winston Excel Worksheet Functions 8 January 2nd 07 12:58 AM
How can I find cell contains the result of "maximum" formula De Excel Discussion (Misc queries) 6 October 26th 06 08:46 PM
How do I replace a "#N/A" formula result with a blank in excel? yrat Excel Discussion (Misc queries) 6 April 3rd 06 04:38 AM


All times are GMT +1. The time now is 06:54 AM.

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"