Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
You'll have to provide some more details to get useful help.
What are the formulas? What are the values of the precedent cells? What result did you expect and what did you get instead? What do you mean if you say "Doesn't work"? -- Kind Regards, Niek Otten Microsoft MVP - Excel "Newsgal" wrote in message ... 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 |
#3
|
|||
|
|||
Post your formula and post the formula in the cell you are checking that does
not work, it's impossible to know otherwise except that it should work. Regards, Peo Sjoblom "Newsgal" wrote: 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 |
#4
|
|||
|
|||
On Tue, 24 May 2005 10:56:04 -0700, "Newsgal"
wrote: 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? It is likely that your formula is returning a result that appears valid but is not. One common error is to have your formula return a TEXT string that looks like a number; and your IF statement is checking for a true number. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How To Use Cells Without Values in a Formula | Excel Worksheet Functions | |||
Need Formula or Function to calculate Margin (reverse of Percent a | Excel Worksheet Functions | |||
Function to look at two cells and return a third | Excel Worksheet Functions | |||
I there an easy way to find out if any formula reference a cell? | New Users to Excel | |||
A formula to check differrent cells | Excel Worksheet Functions |