ms works less vba

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
Click to expand...
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.
 
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
Click to expand...
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.
 
Back
Top