stevestojan Posted February 22, 2005 Author Posted February 22, 2005 Rubes said: 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 IBTG81 said: 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 stevestojan said: 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 stevestojan said: 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 Rubes said: 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 stevestojan said: 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 Rubes said: 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 clumping platelets said: 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 Rubes said: 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 VABills said: 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