LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 12th 05, 09:05 PM posted to microsoft.public.excel.worksheet.functions
Posts: n/a
Default Forcing data into a cell

I have a spreadsheet for bonus calculations (see earlier post). There is a
column of cells from 0 to 100% performance figures. We want to start the
bonus at an amount input into a cell, say e4, we also have a starting
performance %age at which this figure will start in say cell e5. Other data
gives us a figure that the bonus payment then increments by for each %age
increase in performance this is in cell e8

%age Bonus e4=33
30 50
31 50
32 50 e8=2.44
33 50
34 52.44
35 54.88
36 57.32

Entering 33 in e4 causes the information in e5 to be forced into cell next
to the cell containing the performance figure of 35% and makes all cell less
than 33 become the same as 33. At the same time all cells above 33 add the
increment from e8 to the preceding cell. If cell e4 was to become 50 the
same would happen and if it was 12 again cells above in the table would
become the same as 12 the rest would incremment by e8.



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
From several workbooks onto one excel worksheet steve Excel Discussion (Misc queries) 6 December 1st 05 08:03 AM
mass cell data editing George B. Excel Worksheet Functions 2 August 25th 05 08:23 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Repeat Cell Data Pinky Excel Worksheet Functions 1 January 18th 05 05:38 PM
sending data from one cell to another (not using copy & paste) Charlie Payne Excel Worksheet Functions 3 December 6th 04 03:28 PM

All times are GMT +1. The time now is 06:21 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017