Excel spreadsheet formula

G

Grammy D

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

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?
 
S

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?
| >
| >
|
|
 
Top