How do I get a formula in one cell to read the results of a formula in another cell?

I have this formula in cell D8: =IF(ISBLANK(C8),"",IF(AND(C8<=G8)*C8>=F8,"PASS","FAIL"))

I want the formula in D8 to calculate its result based on the result of a formula in F8 and G8. Can this be done?

The formula in F8 is =IF(ISBLANK(C8),"",IF(AND(G3=250)*G4=0.5,"0.484",""))

The formula in G8 is =IF(ISBLANK(C8),"",IF(AND(G3=250)*G4=0.5,"0.516",""))

Hehe its easy replace the value of F8 with the formula in F8 and same with G8,

Please Login or Register  to view this content.

*Mark Solved if worked , else attach a raw sheet to investigate your requirement.

Hi

I believe your problem is that your current formula in cell [D8] is assuming the results in cells [F8] and [G8] are numeric.
But they are not, because you have them as text values "0.484" and "0.516" etc etc etc

So try this:
(Note: I have removed the text quotation marks surrounding 0.484 and 0.516)...
in F8 : =IF(ISBLANK(C8),"",IF(AND(G3=250)*G4=0.5,0.484,""))
in G8: =IF(ISBLANK(C8),"",IF(AND(G3=250)*G4=0.5,0.516,""))

Then..
In cell D8: =IF(ISBLANK(C8),"",IF(AND(C8<=G8,C8>=F8),"PASS","FAIL"))

Please let me know if this sorts it out for you
zeddy

Hi Ford

I would suggest that the purpose of the formula in cell [D8] is clearly to test whether a value in cell [C8] is within the lower and upper limits of a value range given in cells [F8] and [G8] respectively. The test would give either a PASS or FAIL.

With the original formulas as quoted in post#1, there could NEVER be a result of PASS in cell [D8]
..because the lower/upper limits being checked against were NOT numeric values. They were text values.

We'll ignore the misuse of AND in the [F8] and [G8] formulas, probably meant to use..
[F8] =IF(ISBLANK(C8),"",IF(AND(G3=250,G4=0.5),0.484,""))
[G8] =IF(ISBLANK(C8),"",IF(AND(G3=250,G4=0.5),0.516,""))

Excel formulas will always "see" what a cell displays

For someone who has lots of green blobs, you would know that you shouldn't use excel formulas to test against "what is displayed" since the 'displayed' value of a cell doesn't always match up with the actual cell value.

For example, =IF(G5="$5.00","paid","owing") will NEVER show "paid" even if cell G5 shows as $5.00 (i.e. formatted as currency etc etc etc) because this formula is trying to compare a text value with a numeric value. Just saying.

zeddy

Hi Ford

I did understand the point you were making.
I was just being annoying and making a point about what Excel "sees" and what is "displayed".
Try this in your Excel2016:
[A1] = TODAY()
[B1] = 5
[C1] = 10
[D1] = IF($B$1<$C1,TODAY()-7,FORMULATEXT($A$1))

..so what do you see in cell [D1] if you change [B1] from 5 to 12?

Hopefully, the original poster from Montana has the answer they were looking for.
Well, regarding the Excel formula that is.

zeddy

Hi

You are beginning to see the confusion then.
What you are saying is if D1 contains a formula, then it will show the result of the formula.
Yes, that's what Excel does.

Ford says "formula1 that references a formula2 (even those examples you mention) STILL displays the answer for formula2"

So the D1 (formula1) references a cell, A1, that contains a formula (formula2).

But the 'answer' for formula2 (in A1) can be shown in cell A1 in many ways, depending on how you have formatted the display option for cell A1, i.e. the 'answer' for formula2 can show as 18/01/2020 or 18-Jan-2020 or 43848 or 01/18/20 etc etc etc

And if you put a 12 in cell B2 then according to Ford "formula1 that references a formula2 (even those examples you mention) STILL displays the answer for formula2". But formula1 does not display the answer for formula2. Because the answer for formula2, as shown in A1, is a date value.

zeddy

You:

Excel sees the underlying value

- I agree

Ford (post#4) :

D8 will "see" whatever F8 displays

(my italics)

zeddy

No criticism of Ford intended - it's just that the English language is tough enough as it is.
It's the only one I know where "fat chance" means the same as "slim chance"

zeddy