Forum Discussion
Ralfi350
Mar 01, 2023Copper Contributor
Difficult excel formular with many factors
Hi all, it's the first time here for getting your support and really hope to get an answer which brings me forward. The task is to get a result which is influenced of following data: A sales manag...
HansVogelaar
Mar 01, 2023MVP
Ralfi350
Mar 02, 2023Copper Contributor
Hi Hans,
thanks for your comment and proposal. The numbers 1,03 / 1,05 ... I can add in between to get the result which is fine.
Do you know how I can solve the problem for the last bonus step as here I have to count 1,08 and any higher value, means = and > of 1,08?
Best
Ralf
- HansVogelaarMar 02, 2023MVP
The formula should already handle that. Have you tried it?
- Ralfi350Mar 02, 2023Copper ContributorI have adjusted it to be on the save side with another line and >1,08 and yes everything works perfectly. Thank you so much for your support. have a nice evening. Best Ralf