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.
> Thanks, Richard
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
> 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. Copy drag the formula across to columns
I and J. The "$" signs prevent the column letter ("G") changing when you
drag the formula across; without it the column letter would "increment" by
one, as you drag to the right, to become H, I, ... which is *not* what you
need.
If my assumption about your definition of "equal" is wrong, please tell us
what your definition is and we'll try again.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
