Captive Revenue.xlsx
I am trying to insert the following formula in my attached excel spreadsheet:
=IF(B10<(0.05),0.2,IF(AND((B10>=0.05),(B10<.10)),0.15, IF(AND((B10>=.10), (B10<.25)),0.10, IF(AND((B10>=.25), (B10<.50)),0.05, IF(B10>=0.50),0,
The goal here is to look at row B10 and depending on the value insert the value I have in the code. I'm not an expert in excel and having a hard time correcting the problem. Thanks so much for any help you can provide!
Hi jareid76,
You'll be better off creating a table with all the appropriate rates and different levels of loss rates and use a LOOKUP rather than nested IFs. I've created a quick example in the file you uploaded. See if that suits you.
From what i can see, all your IF's are tiered
therefore you dont need all the AND's
Formula:
Please Login or Register to view this content.
Last edited by humdingaling; 07-08-2015 at 02:14 AM. Reason: rephrased and grammar
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
alternate way of using lookup without table
Formula:Please Login or Register to view this content.
Reply withdrawn
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks