stevestojan Posted February 22, 2005 Author Posted February 22, 2005 use the conditional IF statement. so if A1=50 and B1=100, then set C1=A1/B1 and D1=B1/A1 now set E1 = IF(C1>D1, C1 & ":1", "1:" & D1) This way it will check to see which is greater, and use either XXX:1 or 1:XXX. 248405[/snapback] See, this would work, but it's adding a new cell (D1). I would much rather not do that.
clumping platelets Posted February 22, 2005 Posted February 22, 2005 I now remember why i hate using Excel. 248396[/snapback] I was just thinking the same thing
Rubes Posted February 22, 2005 Posted February 22, 2005 See, this would work, but it's adding a new cell (D1). I would much rather not do that. 248424[/snapback] Okay, smarty pants. Set C1 to equal: C1 = IF(A1>B1,LEFT(A1/B1,4)&":1","1:"&LEFT(B1/A1,4)) This should do it for you.
VABills Posted February 22, 2005 Posted February 22, 2005 So Steve, trying to automate your booky stuff?
Mehser Posted February 22, 2005 Posted February 22, 2005 hmmm... that didn't work #NAME? (god, i hate seeing that) 248419[/snapback] If that is th error message you are seeing, then make sure there was not a typo anywhere. That means it does not recognize Quotient.
stevestojan Posted February 22, 2005 Author Posted February 22, 2005 Okay, smarty pants. Set C1 to equal: C1 = IF(A1>B1,LEFT(A1/B1,4)&":1","1:"&LEFT(B1/A1,4)) This should do it for you. 248429[/snapback] Thank you everyone. And to Rubes, you are the MAN... perfect, exactly what I was looking for Thanks for your help...
Rubes Posted February 22, 2005 Posted February 22, 2005 Thank you everyone. And to Rubes, you are the MAN... perfect, exactly what I was looking for Thanks for your help... 248447[/snapback] More like the GEEK, but I'll take it.
clumping platelets Posted February 22, 2005 Posted February 22, 2005 Okay, smarty pants. Set C1 to equal: C1 = IF(A1>B1,LEFT(A1/B1,4)&":1","1:"&LEFT(B1/A1,4)) This should do it for you. 248429[/snapback]
Rubes Posted February 22, 2005 Posted February 22, 2005 248498[/snapback] what? this coming from the only guy I know who can make sense out of the salary cap situation?
clumping platelets Posted February 22, 2005 Posted February 22, 2005 what?this coming from the only guy I know who can make sense out of the salary cap situation? 248537[/snapback] You'd be surprised at how basic my spreadhseets are. I'm sure I could be more productive if I were just willing to do a few things like create a macro to always calculate the top 51 cap charges
Dan Gross Posted February 22, 2005 Posted February 22, 2005 So Steve, trying to automate your booky stuff? 248431[/snapback] If he were, he wouldn't be trying to simplify everything down to :1 or 1: odds, he'd be looking to do 3:4 instead of 0.75:1 ....
Recommended Posts