I have a formula I put together that is perfect. I need to add to this
If the result is less than .001 than make the result 9999.99
Here is my formula. Thanks for help
=IFERROR(INDEX('Stored Values'!$U$60:$U$1260,MATCH(1,IF('Stored Values'!$D$60:$D$1260='Rate Rank Summary'!D20,IF('Stored Values'!$G$60:$G$1260='Rate Rank Summary'!$F$19,IF('Stored Values'!$F$60:$F$1260='Stored Values'!$F$5,1))),0)),"None")
Bookmarks