Refer to formula in another sheet
Hi
I think you need to be explicit as to which G16 you want.
Put Sheet3! in front of the cell identity in the formulae
In sheet1: IF($S$4={"O"};"",IF(Sheet3!G16<=$T$7;0))
In sheet2: IF($S$4={"H"},IF(Sheet3!G16<=$T$7;0))
Regards
Roger Govier
Jonsson wrote:
Hi all,
I have an IF formula that need to be testing more than seven
statements.
The question is if it is possible to split the IF-statement in two
different cells, and then get them wether the conditions is right or
not.
Like this:
In sheet1: IF($S$4={"O"};"",IF(G16<=$T$7;0
In sheet2: IF($S$4={"H"},IF(G16<=$T$7;0
The formulas above is not relevant, they are just shown as an example
of what I mean to do in the formula below
In sheet3:
=IF($S$4={"O"},"",IF(AND($S$4={"H"},$T$41000),She et1!M16,Sheet2!M16))
The above idea doesn't work, as it refers to the cell G16 in sheet1 and
sheet2.
I want the IF-formulas in sheet1 and 2 test the values in sheet3 G16.
Is it even possible?
Any respond to this is very helpful!
//Thomas
|