LinkBack URL
About LinkBacks
Formula in E5 can be simplified as below
=ROUND(B5/(1-INDEX({5.6,5.5,5.4,5.3,5.2,5.1},MATCH(B5,{10,25,50,100,175,250}))),0)+0.99
where 5.6 is value in F2
5.5 is value in E2 ... so on
Formula in E5 can be simplified as below
=ROUND(B5/(1-INDEX({5.6,5.5,5.4,5.3,5.2,5.1},MATCH(B5,{10,25,50,100,175,250}))),0)+0.99
where 5.6 is value in F2
5.5 is value in E2 ... so on
The provided formula is now able to be integrated with my spread sheet... error = #N/A
nevermind - I was able to modify it to work. Thank you for the information
Last edited by priceisright; 06-20-2011 at 10:46 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks