ms works less vba

[seeker53]

Since ms works 7.0 does not have vba functionality, how can I do the following?

if cell(A3) = "c" THEN the amount entered by the user in b3:h3 needs to show as .5 * the amount the user enters else it is 1 * the amount the user enters in the b3:h3 range of cells. This needs to be available for new rows as they are added. In vba i could use an on exit from the cell and do the calculation but am handicapped in ms works and the client does not want to use excel.

 

[Debra Dalgleish]

A formula can't change the contents of another cell, either in Works or
in Excel. If you post your question in one of the Works newsgroups,
someone may have a suggestion for you:


http://support.microsoft.com/newsgroups/default.aspx?newsgroup=microsoft.public.works.win

 

[Peter Atherton]

You can only add a new line and enter a formula there
e.g =IF($A$3="c",B3*0.5,B3)

Peter Atherton

-----Original Message-----
Since ms works 7.0 does not have vba functionality, how can I do the following?

if cell(A3) = "c" THEN the amount entered by the user in

b3:h3 needs to show as .5 * the amount the user enters
else it is 1 * the amount the user enters in the b3:h3
range of cells. This needs to be available for new rows
as they are added. In vba i could use an on exit from the
cell and do the calculation but am handicapped in ms works
and the client does not want to use excel.

 

[Myrna Larson]

As Debra says, a formula can't do what you want.
One approach is to use another row for the "adjusted" entry, i.e. in B4:H4

=IF($A$3="C",B3*.5,B3)

Since ms works 7.0 does not have vba functionality, how can I do the following?

if cell(A3) = "c" THEN the amount entered by the user in b3:h3 needs to show

as .5 * the amount the user enters else it is 1 * the amount the user enters
in the b3:h3 range of cells. This needs to be available for new rows as they
are added. In vba i could use an on exit from the cell and do the calculation
but am handicapped in ms works and the client does not want to use excel.