In column G, I have three possible combinations, 1/25#,. 6/5#, 10/5# or
4/12.5#. If one multiplies "4 times 12.5#" , one gets "50#". Thanks
again, Richard
Harold Fuchs wrote:
On 16/10/2007, *Richard J Neuenfeldt* <[EMAIL PROTECTED]
<mailto:[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]
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: [EMAIL PROTECTED]
<mailto:[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 users@openoffice.org <mailto:users@openoffice.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
