Richard J Neuenfeldt wrote:
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 [email protected]
<mailto:[email protected]>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
If I were doing this and only had those 4 combinations and I didn't
expect to have a bunch more in the future and the price for 10/5#
($26.65) is the same as the price for 4/12.5# , I would just make the
formula for H1 be:
=IF(OR($G1="10/5#";$G1="4/12.5#");29.15;(IF($G1="6/5#";30;25)))
--
Thanks.
Yours,
**//Charlie
//***/Charles D. Seaman/**/
/* 770-617-1214
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
