LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Newsgal
 
Posts: n/a
Default IF function: Reference cells - Value vs Formula

Spreadsheet has IF Function that refers to a cell with a formula instead of a
hard entered value. Doesn't work when formula is in cell. Works when formula
is overridden by hard entering value even when hard entered number matches
number as result of formula. Can this be fixed?
--
News Gal
 
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
How To Use Cells Without Values in a Formula Roger H. Excel Worksheet Functions 2 April 6th 05 01:01 AM
Need Formula or Function to calculate Margin (reverse of Percent a Ken Excel Worksheet Functions 1 February 7th 05 09:26 AM
Function to look at two cells and return a third jlmam Excel Worksheet Functions 2 January 26th 05 04:41 PM
I there an easy way to find out if any formula reference a cell? Marc New Users to Excel 1 December 6th 04 10:41 PM
A formula to check differrent cells Carlsbad Excel Worksheet Functions 0 October 28th 04 01:19 AM


All times are GMT +1. The time now is 06:20 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"