LinkBack URL
About LinkBacks
Hi,
I want to make a rating system, where depending on the value on C7 (refer to attached worksheet), C9 will have a rating.
I have attached the worksheet to this (its all there), hopefully someone can help me.
Thanks,
Excel rating system
Hi,
I want to make a rating system, where depending on the value on C7 (refer to attached worksheet), C9 will have a rating.
I have attached the worksheet to this (its all there), hopefully someone can help me.
Thanks,
Here, try this:
=REPT("$", 3+MAX(-2, INT(J15/10000)))
Never use Merged Cells in Excel
Will this be dynamic, so like if the value changes, the rating changes?Originally Posted by zbor
yes.. It's just don't have maximum of $ (but have minimum)...
So for profit 100.000.000 you will have $$$$$$$$$ if that's OK.
or use this for maximum 5 $ signs:
=REPT("$", MIN(5, 3+MAX(-2, INT(A1/10000))))
Last edited by zbor; 08-29-2011 at 07:02 AM.
mmm.....its not quite what I was looking for then...its got to be those the 1 - 5 dollar symbols..
read above post to the end
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks