Ottsel
Board Regular
- Joined
- Jun 4, 2022
- Messages
- 174
- Office Version
- 365
- Platform
- Windows
I currently use the 'What-If Analysis' > Goal Seek on multiple rows of data to get a certain percentage that I need to reach.
I'm trying to make it, so if I were to select a vector of cells I could make them reference column F to change to my desired percentage. In this case: I need column D to change until F = '-10.0%'
The 'Goal Seek' function works wonderfully on small tables of data, but to use it on hundreds of rows can be very time consuming, so I was attempting to speed it up.
The reason I'm attempting this method is because E uses column D and A to get its amount, so it can be conflicting.
A: is a hard number
B:
C:
D: is a hard number
E:
F: References another sheet.
I'm trying to make it, so if I were to select a vector of cells I could make them reference column F to change to my desired percentage. In this case: I need column D to change until F = '-10.0%'
The 'Goal Seek' function works wonderfully on small tables of data, but to use it on hundreds of rows can be very time consuming, so I was attempting to speed it up.
The reason I'm attempting this method is because E uses column D and A to get its amount, so it can be conflicting.
A: is a hard number
B:
Excel Formula:
=IF(OR(Z339=0,AD339=0),0,AD339-Z339)
Excel Formula:
=IF(Z339=0,0,IF(OR(AA339/Z339>1,AA339/Z339<-1),0,AA339/Z339))
E:
Excel Formula:
=IF(S339+Y339>=0,CEILING(S339+Y339,5),FLOOR(S339+Y339,-5))+AC339+G339