perhol
10-04-2007, 05:51 PM
First of all, I am sorry that my english is so poor!:dunno
I am about to make a sheet that requires som complicated calculations.
In cell B8 i enter a value between 4 and >22. Depending on that value the sheet should calculate a value in cells E8 and C14.
The value in C14 can only be 30 minutes, 1 hour or 2 hours and gives the time for next control.
Values, entered in B8 should be stored in a list on another sheet (valuesheet) in the same file. First value entered should be stored in A1 on the valuesheet. Following values should be stored in next empty cell in column A
The value calculated in cell E8 is a decimal value with 1 decimal depending on the following conditions:
If the first value entered in B8 is 8.3 trough 12 E8 should be 2 and C14 should be 1 hour.
If the first value entered in B8 is 12.1 trough 22 E8 should be 4 and C14 should be 1 hour.
After first value in B8:
If B8 is less or equal to 4 E8 should be 0 (zero) and C14 should be 30 minutes.
If B8 is 4.1 trough 4.5 E8 should be reduced with 2 if currently the value in B8 is bigger than 5 and C14 should be 30 minutes.
If B8 is 4.1 trough 4.5 E8 should be reduced with 0.5 if currently the value in B8 is less or equal to 5 and C14 should be 30 minutes.
If B8 is 4.6 trough 8.2 E8 should not change and C14 should be 2 hours.
If B8 is 8.3 trough 10 and the value is falling E8 should not change and C14 should be 1 hour.
If B8 is 8.3 trough 10 and the value is raising E8 should raise with 1 and C14 should be 1 hour.
If B8 is 10.1 trough 14 and the value is falling E8 should not change and C14 should be 1 hour.
If B8 is 10.1 trough 14 and the value is raising E8 should raise with 1.5 and C14 should be 1 hour.
If B8 is 14.1 trough 22 E8 should raise with 2 and C14 should be 1 hour.
If B8 is equal or more than 22 E8 should be "Individual evaluation" and C14 should be empty.
If B8 is 4.6 trough 14 and the value is falling with more than 50% E8 should be reduced with 50% and C14 should be 1 hour.
All of this is far more complicated than what i have made in excel before. Please help.:help
I am about to make a sheet that requires som complicated calculations.
In cell B8 i enter a value between 4 and >22. Depending on that value the sheet should calculate a value in cells E8 and C14.
The value in C14 can only be 30 minutes, 1 hour or 2 hours and gives the time for next control.
Values, entered in B8 should be stored in a list on another sheet (valuesheet) in the same file. First value entered should be stored in A1 on the valuesheet. Following values should be stored in next empty cell in column A
The value calculated in cell E8 is a decimal value with 1 decimal depending on the following conditions:
If the first value entered in B8 is 8.3 trough 12 E8 should be 2 and C14 should be 1 hour.
If the first value entered in B8 is 12.1 trough 22 E8 should be 4 and C14 should be 1 hour.
After first value in B8:
If B8 is less or equal to 4 E8 should be 0 (zero) and C14 should be 30 minutes.
If B8 is 4.1 trough 4.5 E8 should be reduced with 2 if currently the value in B8 is bigger than 5 and C14 should be 30 minutes.
If B8 is 4.1 trough 4.5 E8 should be reduced with 0.5 if currently the value in B8 is less or equal to 5 and C14 should be 30 minutes.
If B8 is 4.6 trough 8.2 E8 should not change and C14 should be 2 hours.
If B8 is 8.3 trough 10 and the value is falling E8 should not change and C14 should be 1 hour.
If B8 is 8.3 trough 10 and the value is raising E8 should raise with 1 and C14 should be 1 hour.
If B8 is 10.1 trough 14 and the value is falling E8 should not change and C14 should be 1 hour.
If B8 is 10.1 trough 14 and the value is raising E8 should raise with 1.5 and C14 should be 1 hour.
If B8 is 14.1 trough 22 E8 should raise with 2 and C14 should be 1 hour.
If B8 is equal or more than 22 E8 should be "Individual evaluation" and C14 should be empty.
If B8 is 4.6 trough 14 and the value is falling with more than 50% E8 should be reduced with 50% and C14 should be 1 hour.
All of this is far more complicated than what i have made in excel before. Please help.:help