stevestojan Posted February 22, 2005 Author Share 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. Link to comment Share on other sites More sharing options...
clumping platelets Posted February 22, 2005 Share Posted February 22, 2005 I now remember why i hate using Excel. 248396[/snapback] I was just thinking the same thing Link to comment Share on other sites More sharing options...
Rubes Posted February 22, 2005 Share 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. Link to comment Share on other sites More sharing options...
VABills Posted February 22, 2005 Share Posted February 22, 2005 So Steve, trying to automate your booky stuff? Link to comment Share on other sites More sharing options...
Mehser Posted February 22, 2005 Share 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. Link to comment Share on other sites More sharing options...
stevestojan Posted February 22, 2005 Author Share 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... Link to comment Share on other sites More sharing options...
Rubes Posted February 22, 2005 Share 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. Link to comment Share on other sites More sharing options...
clumping platelets Posted February 22, 2005 Share 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] Link to comment Share on other sites More sharing options...
Rubes Posted February 22, 2005 Share 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? Link to comment Share on other sites More sharing options...
clumping platelets Posted February 22, 2005 Share 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 Link to comment Share on other sites More sharing options...
Dan Gross Posted February 22, 2005 Share 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 .... Link to comment Share on other sites More sharing options...
Recommended Posts