Nov 16 2021 08:26 PM - edited Nov 16 2021 08:47 PM
Nov 16 2021 08:57 PM
Here is a quick solution
File inserted as an example
=IF(I4<"2.9999",(C7*50),IF(I4>5,(C7*65),IF(I4<"4.999",(I4*55),IF(I4>3,(C7*55),""))))
Additional Info:
IF function – nested formulas and avoiding pitfalls
While Excel will allow you to nest up to 64 different IF functions, it’s not at all advisable to do so. Why?
more info about IF functions in the upper link :)
Hope I was able to help you with this info.
NikolinoDE
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.
Nov 16 2021 09:04 PM
Nov 16 2021 09:22 PM - edited Nov 16 2021 09:23 PM
Can you give me some example I4 values and what you expect the result to be? Based on my understanding of your problem, my formula is returning the right values (I must be misreading your problem - sorry)
Nov 16 2021 09:43 PM
Nov 16 2021 09:55 PM
Nov 16 2021 10:42 PM
Nov 17 2021 12:46 AM