if (true) (false) function

  • Thread starter Thread starter Wai Keong
  • Start date Start date
W

Wai Keong

To anyone who is willing to help,

I am trying to calculate value in a cell which uses the
number at another cell that reference has been made. But
the calculation does not show except the formula itself.

E.g. Cell C3 formula [ =IF(A3>0,"(A3-20)/10*C2+C1),0) ]

A B C D
1 0.28
2 0.70
3 150 formula cell
4


Many thanks.
 
What is the question? That formula looks fine as it is. What is not working
with it?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Make sure the cell is not formatted as Text (general is ok).

Make sure you don't have any spaces before the leading equal sign.

And watch out for that extraneous double quote and the close parenthesis after
C1. It doesn't look right (but maybe that's a newsgroup post typo).


And even though you don't need them, I like to put parentheses around this kind
of stuff--it makes it easier for me when I'm checking things:

=IF(A3>0,((A3-20)/(10*C2))+C1,0)

might be one way--but make sure it's got the operations in the order that you
really want.



Wai said:
To anyone who is willing to help,

I am trying to calculate value in a cell which uses the
number at another cell that reference has been made. But
the calculation does not show except the formula itself.

E.g. Cell C3 formula [ =IF(A3>0,"(A3-20)/10*C2+C1),0) ]

A B C D
1 0.28
2 0.70
3 150 formula cell
4

Many thanks.
Click to expand...
 
HI Bob,

Well, under C3 which I wanted the result, it just showed
the formula as indicated in my E.g. It did not do any
calculation.

Thanks a lot. Appreciate your help.
-----Original Message-----
What is the question? That formula looks fine as it is. What is not working
with it?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Wai Keong said:
To anyone who is willing to help,

I am trying to calculate value in a cell which uses the
number at another cell that reference has been made. But
the calculation does not show except the formula itself.

E.g. Cell C3 formula [ =IF(A3>0,"(A3-20)/10*C2+C1),0) ]

A B C D
1 0.28
2 0.70
3 150 formula cell
4


Many thanks.
Click to expand...


.
Click to expand...
 
The cell A3 suppose to return a calculated answer but it
showed the formula instead. Any advice.

Thanks in advance.

W K
-----Original Message-----
What is the question? That formula looks fine as it is. What is not working
with it?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Wai Keong said:
To anyone who is willing to help,

I am trying to calculate value in a cell which uses the
number at another cell that reference has been made. But
the calculation does not show except the formula itself.

E.g. Cell C3 formula [ =IF(A3>0,"(A3-20)/10*C2+C1),0) ]

A B C D
1 0.28
2 0.70
3 150 formula cell
4


Many thanks.
Click to expand...


.
Click to expand...
 
Make sure that the cell is not formatted as Text, change it to General.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

The cell A3 suppose to return a calculated answer but it
showed the formula instead. Any advice.

Thanks in advance.

W K
-----Original Message-----
What is the question? That formula looks fine as it is. What is not working
with it?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Wai Keong said:
To anyone who is willing to help,

I am trying to calculate value in a cell which uses the
number at another cell that reference has been made. But
the calculation does not show except the formula itself.

E.g. Cell C3 formula [ =IF(A3>0,"(A3-20)/10*C2+C1),0) ]

A B C D
1 0.28
2 0.70
3 150 formula cell
4


Many thanks.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top