Bet nobody can answer this one. And i didn’t start-our pessimisti

D

Denny Crane

Bet nobody can answer this one. And i didn’t start-our pessimistic…It may be
the Madcow

All in same workbook:

1) Sheet1 has a cell G7containing the formula =F7*(1-0.12313) which
calculatesa value from another cell
2) Sheet2 has a cell D19 containing the formula =F19/26 which calculates
a value
from another cell
3) Sheet3 has a cell H8 which I want to contain the same value of SHEET2!
D19 “BUT, ONLY†when there’s a calculated value in SHEET1!G7

I have tried in SHEET3 H8:
Ø =IF(ISNUMBER(SHEET1!G7),"",SHEET2!$D$19)
Ø
Ø =IF(ISBLANK(SHEET1!G7),"",SHEET2!$D$19)
Ø
Ø =IF(SHEET1!G7="","",SHEET2!$D$19)

You have my appreciation in advance for your efforts, successful or not.

Thanks

Denny Crain
 
T

Terry Bennett

Denny

I may be misunderstanding what you are trying to do but is it not just a
case of:

=IF(Sheet1!G7<>0,Sheet2!D19,0)

in Sheet 3 Cell H8?

Terry
 
N

Niek Otten

Hi Denny,

<BUT, ONLY" when there's a calculated value in SHEET1!G7>

There is always a calculated value in SHEET1!G7. What exactly do you mean with "calculated value"?
 
R

Richard Buttrey

Bet nobody can answer this one. And i didn’t start-our pessimistic…It may be
the Madcow

All in same workbook:

1) Sheet1 has a cell G7containing the formula =F7*(1-0.12313) which
calculatesa value from another cell
2) Sheet2 has a cell D19 containing the formula =F19/26 which calculates
a value
from another cell
3) Sheet3 has a cell H8 which I want to contain the same value of SHEET2!
D19 “BUT, ONLY” when there’s a calculated value in SHEET1!G7

I have tried in SHEET3 H8:
Ø =IF(ISNUMBER(SHEET1!G7),"",SHEET2!$D$19)
Ø
Ø =IF(ISBLANK(SHEET1!G7),"",SHEET2!$D$19)
Ø
Ø =IF(SHEET1!G7="","",SHEET2!$D$19)

You have my appreciation in advance for your efforts, successful or not.

Thanks

Denny Crain
Click to expand...

I'm assuming by calculated value you mean something <> 0

=IF(ABS(Sheet1!G7)>0,Sheet2!D19,"")

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
B

Biff

Hi!
Sheet3 has a cell H8 which I want to contain the same value of SHEET2!
D19 "BUT, ONLY" when there's a calculated value in SHEET1!G7
Click to expand...
Sheet1 has a cell G7containing the formula =F7*(1-0.12313)
Click to expand...

Unless F7 contains text or some other logical error value (in which case,
the formula would return an error), the formula, =F7*(1-0.12313), will
always return a calculated value. So, "BUT, ONLY" when there's a calculated
value in SHEET1!G7, would be always.

Biff
 
Top