software

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),quot;quot;,SHEET2!$D$19)
Ø
Ø=IF(ISBLANK(SHEET1!G7),quot;quot;,SHEET2!$D$19)
Ø
Ø=IF(SHEET1!G7=quot;quot;,quot;quot;,SHEET2!$D$19)

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

Thanks

Denny CrainDenny

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

=IF(Sheet1!G7lt;gt;0,Sheet2!D19,0)

in Sheet 3 Cell H8?

Terry

quot;Denny Cranequot; gt; wrote in message
...
gt; Bet nobody can answer this one. And i didn't start-our pessimistic.It may
gt; be
gt; the Madcow
gt;
gt; All in same workbook:
gt;
gt; 1) Sheet1 has a cell G7containing the formula =F7*(1-0.12313) which
gt; calculatesa value from another cell
gt; 2) Sheet2 has a cell D19 containing the formula =F19/26 which
gt; calculates
gt; a value
gt; from another cell
gt; 3) Sheet3 has a cell H8 which I want to contain the same value of
gt; SHEET2!
gt; D19 quot;BUT, ONLYquot; when there's a calculated value in SHEET1!G7
gt;
gt; I have tried in SHEET3 H8:
gt; � =IF(ISNUMBER(SHEET1!G7),quot;quot;,SHEET2!$D$19)
gt; �
gt; � =IF(ISBLANK(SHEET1!G7),quot;quot;,SHEET2!$D$19)
gt; �
gt; � =IF(SHEET1!G7=quot;quot;,quot;quot;,SHEET2!$D$19)
gt;
gt; You have my appreciation in advance for your efforts, successful or not.
gt;
gt; Thanks
gt;
gt; Denny Crain
gt;
Hi Denny,

lt;BUT, ONLYquot; when there's a calculated value in SHEET1!G7gt;

There is always a calculated value in SHEET1!G7. What exactly do you mean with quot;calculated valuequot;?

--
Kind regards,

Niek Ottenquot;Denny Cranequot; gt; wrote in message ...
gt; Bet nobody can answer this one. And i didn't start-our pessimistic.It may be
gt; the Madcow
gt;
gt; All in same workbook:
gt;
gt; 1) Sheet1 has a cell G7containing the formula =F7*(1-0.12313) which
gt; calculatesa value from another cell
gt; 2) Sheet2 has a cell D19 containing the formula =F19/26 which calculates
gt; a value
gt; from another cell
gt; 3) Sheet3 has a cell H8 which I want to contain the same value of SHEET2!
gt; D19 quot;BUT, ONLYquot; when there's a calculated value in SHEET1!G7
gt;
gt; I have tried in SHEET3 H8:
gt; � =IF(ISNUMBER(SHEET1!G7),quot;quot;,SHEET2!$D$19)
gt; �
gt; � =IF(ISBLANK(SHEET1!G7),quot;quot;,SHEET2!$D$19)
gt; �
gt; � =IF(SHEET1!G7=quot;quot;,quot;quot;,SHEET2!$D$19)
gt;
gt; You have my appreciation in advance for your efforts, successful or not.
gt;
gt; Thanks
gt;
gt; Denny Crain
gt;
On Sun, 12 Mar 2006 13:38:26 -0800, Denny Crane
gt; wrote:

gt;Bet nobody can answer this one. And i didn�t start-our pessimistic�It may be
gt;the Madcow
gt;
gt;All in same workbook:
gt;
gt;1) Sheet1 has a cell G7containing the formula =F7*(1-0.12313) which
gt; calculatesa value from another cell
gt;2) Sheet2 has a cell D19 containing the formula =F19/26 which calculates
gt;a value
gt; from another cell
gt;3) Sheet3 has a cell H8 which I want to contain the same value of SHEET2!
gt; D19 �BUT, ONLY� when there�s a calculated value in SHEET1!G7
gt;
gt;I have tried in SHEET3 H8:
gt;�=IF(ISNUMBER(SHEET1!G7),quot;quot;,SHEET2!$D$19)
gt;�
gt;�=IF(ISBLANK(SHEET1!G7),quot;quot;,SHEET2!$D$19)
gt;�
gt;�=IF(SHEET1!G7=quot;quot;,quot;quot;,SHEET2!$D$19)
gt;
gt;You have my appreciation in advance for your efforts, successful or not.
gt;
gt;Thanks
gt;
gt;Denny Crain

I'm assuming by calculated value you mean something lt;gt; 0

=IF(ABS(Sheet1!G7)gt;0,Sheet2!D19,quot;quot;)

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Hi!

gt;Sheet3 has a cell H8 which I want to contain the same value of SHEET2!
gt;D19 quot;BUT, ONLYquot; when there's a calculated value in SHEET1!G7

gt;Sheet1 has a cell G7containing the formula =F7*(1-0.12313)

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, quot;BUT, ONLYquot; when there's a calculated
value in SHEET1!G7, would be always.

Biff

quot;Denny Cranequot; gt; wrote in message
...
gt; Bet nobody can answer this one. And i didn't start-our pessimistic.It may
gt; be
gt; the Madcow
gt;
gt; All in same workbook:
gt;
gt; 1) Sheet1 has a cell G7containing the formula =F7*(1-0.12313) which
gt; calculatesa value from another cell
gt; 2) Sheet2 has a cell D19 containing the formula =F19/26 which
gt; calculates
gt; a value
gt; from another cell
gt; 3) Sheet3 has a cell H8 which I want to contain the same value of
gt; SHEET2!
gt; D19 quot;BUT, ONLYquot; when there's a calculated value in SHEET1!G7
gt;
gt; I have tried in SHEET3 H8:
gt; � =IF(ISNUMBER(SHEET1!G7),quot;quot;,SHEET2!$D$19)
gt; �
gt; � =IF(ISBLANK(SHEET1!G7),quot;quot;,SHEET2!$D$19)
gt; �
gt; � =IF(SHEET1!G7=quot;quot;,quot;quot;,SHEET2!$D$19)
gt;
gt; You have my appreciation in advance for your efforts, successful or not.
gt;
gt; Thanks
gt;
gt; Denny Crain
gt;