Excel spreadsheet formula

[Guest]

How do I create a formula that would make one column 10% less than the previous column?

 

[Stefan B Rusynko]

Try an Excel Newsgroup
PS
The formula in B1 would be
=A1-A1*1

--




"Grammy D" <grammyd22004> wrote in message | How do I create a formula that would make one column 10% less than the previous column?

 

[Bob Lehmann]

=A1*.9

Bob Lehmann

How do I create a formula that would make one column 10% less than the

previous column?

 

[Bob Lehmann]

Doesn't that = 0?

Bob Lehmann?

 

[Stefan B Rusynko]

Yep
was missing the decimal
=A1-A1*.1

--




| Doesn't that = 0?
|
| Bob Lehmann?
|
| | > Try an Excel Newsgroup
| > PS
| > The formula in B1 would be
| > =A1-A1*1
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > "Grammy D" <grammyd22004> wrote in message
| | > | How do I create a formula that would make one column 10% less than the
| previous column?
| >
| >
|
|