Forum Discussion
formula help please
Badger_Z I'm a mathematician and perhaps therefore don't understand the your intentions with the LN function. But if I interpret your question correctly, I believe the following formula works as intended:
=IF(G24<$G$25,(G24/$G$25)*0.75,IF(G24>=1.1*$G$25,1,0.75+(G24-$G$25)/($G$25*10%)*0.25))
Badger_Z I'm a mathematician and perhaps therefore don't understand the your intentions with the LN function. But if I interpret your question correctly, I believe the following formula works as intended:
=IF(G24<$G$25,(G24/$G$25)*0.75,IF(G24>=1.1*$G$25,1,0.75+(G24-$G$25)/($G$25*10%)*0.25))
Riny_van_Eekelen That looks like it worked! I don't know the rationale behind the LN formula. I'm modifying a worksheet that has been in use since 2012 so I don't know the original intent of the LN formula. I'm no mathematician so I really appreciate your help! Thank you!
Badger_Z Actuallt, I made a mistake in my previous post. I forgot to add the word "not" before "a mathematician". I really am not! That's why I couldn't figure out why you had used LN to capture the 10%. Anyhow, glad that I could you help you!
Riny_van_Eekelen Well you could've fooled me! LOL Thanks for your help. Much appreciated. 🙂
