Since you guys were so helpful on the last one here on last calc in need
95 - 90.01% = 0.84%
90 - 85.01% = 0.62%
85% & Below = 0.45%
All above are a % of F22 ie: 96.5% or 88% or whatever
so
If(f22 is >=90.01% and < 95% the result is .084%) and >85.01 and < 90% = .062%)
and so on
Thanks
Last edited by NBVC; 09-29-2011 at 08:26 AM.
Try:
=LOOKUP(F22,{0,.8501,.9001},{.45,.62,.84})
or
=IF(F22<=0.85,0.45,IF(F22<=.9,.62,.84)
formatted as percentage.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Sorry I have one other variable
f16 has to be "Conv" if not the result should be 0. everything else worked great!
Thanks and sorry for leaving out
Oh and I did the IF forumla..thanks
Try:
=IF(F16="Conv",IF(F22<=0.85,0.45,IF(F22<=.9,.62,.84),0)
Says I have too many arguments
Lost a closing bracket...
=IF(F16="Conv",IF(F22<=0.85,0.45,IF(F22<=0.9,0.62,0.84)),0)
I have the following in my formula and when it is Conv is giving me a 0
=IF(F16="Conv",IF(G22<=85%,0.45,IF(G22<=90%,0.62,0.84)),0)
G22 is the correct cell for the LTV%
sorry
I just fourn the problem I had left the period(.) out of conv.
Works great......I'm an idiot
Thanks so much
Check that F16 doesn't contain any extra leading/trailing spaces.
Sorry I put 85% and below was wrong it <=85% and >=80% it was printed like that and I just copied it and they assumed I knew no PMI below 80% or 0 result
Thanks again
Last edited by garopro; 09-28-2011 at 05:36 PM.
Do you mean?
=IF(F16="Conv",IF(G22<=80%,0,IF(G22<=85%,0.45,IF(G22<=90%,0.62,0.84))),0)
remember to add the . to Conv... not sure where exactly you made that earlier change.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks