LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default Using a result in the same formula.

For example, take a number 100 (A1). In the formula in B1 - take A1 and
multiply it by 10% - TAKE THE RESULT of that and Multiply it by 10% and take
the RESULT of thank and multiply by 10%. Answer should be 72.9 Take 10% of
100 would be 90, 10% of 90 would be 81, 10% of 81 would be 72.9. How do I
write that formula in ONE LINE??????
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula result and displayed result are different spindoctor Excel Worksheet Functions 4 July 15th 09 12:53 AM
Formula result does not match displayed result lothar Excel Worksheet Functions 1 June 23rd 08 05:05 AM
Formula Bar F9 Result differs from cell result??? Aaron Excel Worksheet Functions 3 May 15th 08 06:32 PM
Advanced formula - Return result & Show Cell Reference of result Irv Excel Worksheet Functions 7 May 6th 06 03:36 AM
Median result used in formula gives incorrect result vlatham Excel Worksheet Functions 4 September 21st 05 04:26 PM


All times are GMT +1. The time now is 10:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"