At 09:49 17/10/2007 +0100, Harold Fuchs wrote:
On 16/10/2007, Richard J Neuenfeldt <[EMAIL PROTECTED]> wrote:
> How do you simply formulate the addition of $2.50 to cells H, I, J if
> cell G =50#. For example, if col G has "4/12.5 #", it does equal 50#,
> and I want col H which is now $26.65 to read $29.15 . I wish to do a
> one page spreadsheet of three columns.
Before answering this we need to get straight what you mean by "equal".
You say "if col G has "4/12.5 #", it does equal 50#". That's not my
understanding of "equal".
So, let's assume that what you really mean is "if the last three characters
of col G is either "5 #" or "50#" then add 2.5 to col H".
Given this definition of "equal" then the formula
=IF(OR(RIGHT($G1;3)="50#";RIGHT($G1;3)="5 #");H1+2.5;H1) will do the job.
Copy/drag the formula down column H.
This formula has a circular reference, in that it defines each cell
in terms of itself. And the formula does not converge, so this will
simply produce an error even with "Iterative references" switched on.
The original question is not well defined, in fact ...
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
