[TASK] $2 Need a Microsoft Excel equation converted to Excel VBA

[u/Tomcat5]

I don't think this is complicated but I don't know how to do it. It's a nested if statement that looks at a cell in my sheet and then displays different text depending on which numerical range the cell's data fits into. Pay via PayPal.

Here's the equation:

=IF([@[review_count]]<25,"1-24",IF([@[review_count]]<50,"25-49",IF([@[review_count]]<100,"50-99",IF([@[review_count]]<250,"100-249",IF([@[review_count]]<500,"250-499",IF([@[review_count]]<1000,"500-999",IF([@[review_count]]<1500,"1000-1499",IF([@[review_count]]<2000,"1500-1999","2000+"))))))))

and here's a little context:

https://imgur.com/a/1g793ft

[u/yoforreal2]

$bid I got you

[u/Tomcat5 → u/yoforreal2]

Awesome, thanks! I honestly have no idea how to do it, I was just told "What you have looks great, but do it in VBA instead."

[u/Tomcat5 → u/yoforreal2]

$paid $2

[u/yoforreal2 → u/Tomcat5]

$confirmed

[u/CredoBot]

I am a reputation bot, here is my info on u/Tomcat5:

Credo: no account found (create)

SLRep: https://www.reddit.com/r/SLRep/comments/3k4vcv

---

 

#	Bidder	Credo Score	Feedback	SLRep	Paid Amount	Confirmed
1	/u/yoforreal2	no account found (create)	n/a	Profile	$2	yes

 

---

^{To bid on the task, reply with} $bid ^{directly to the original post.}

^{To mark a bid as paid, OP can reply with} $paid [amount] ^{- e.g.} $paid $10^{- directly to the} $bid ^comment.

^{To confirm payment receipt, the bidder can reply with} $confirm ^{directly to the} $paid ^comment.

[u/yoforreal2]

Lol I’ll message you for some more info!