what am I thinking....
or do I need to do an IIF statement?
Yes.
The lack of a Max() or Min() function in VBA is annoying. (Not to beconfused with Max and Min in SQL.)
eta: OK, here's a worse way of doing it: ((b-a) + Abs(b-a))/2
Stop means no. And no means no. So . . . stop.
Xander ,'Conversations with Dead People'
Buffistechnology 2: You Made Her So She Growls?
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
tommyrot - Oct 06, 2006 11:11:36 am PDT #9142 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
Jon B. - Oct 06, 2006 11:37:38 am PDT #9143 of 10003
A turkey in every toilet -- only in America!
OK, here's a worse way of doing it: ((b-a) + Abs(b-a))/2
Ha!
It is annoying though. All I needed was a way to make a number between 0 and 100% (i.e., no negative percents and nothing greater than 100%), and I had to use nested IIF statements. Ridiculous!
tommyrot - Oct 06, 2006 11:41:28 am PDT #9144 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
You could do:
IIF(b-a <0 Or b-a >100,0,b-a)
(Assuming the numbers have already been converted to %.)
eta: Oh wait, you pro'lly wanna convert >100 to 100, right? Then you gotta do the nested IIF.
Jon B. - Oct 06, 2006 11:45:15 am PDT #9145 of 10003
A turkey in every toilet -- only in America!
Forget the b-a part. That was just an example. I'm actually taking a complicated quotient. But besides that, I think your logic is flawed. Your statement returns 0 if b-a is greater than 100. It should return 100.
t edit Yes, your edit is correct!
tommyrot - Oct 06, 2006 12:05:04 pm PDT #9146 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
If you have to do this sort of calculation a lot, you could just write a function to handle it.
Jessica - Oct 06, 2006 4:08:31 pm PDT #9147 of 10003
If I want to become a cloud of bats, does each bat need a separate vaccination?
could someone post the link to the mobile version of google reader? the standard version keeps crashing my treo (java) and my flight's delayed an hour...
dcp - Oct 06, 2006 4:15:55 pm PDT #9148 of 10003
The more I learn, the more I realize how little I know.
Jessica - Oct 06, 2006 4:18:50 pm PDT #9149 of 10003
If I want to become a cloud of bats, does each bat need a separate vaccination?
oh you are made of awesome!
Cybervixen - Oct 06, 2006 4:42:12 pm PDT #9150 of 10003
Queen of the Drive-By
Hi, is anyone here?
Cybervixen - Oct 06, 2006 4:44:44 pm PDT #9151 of 10003
Queen of the Drive-By
Please please? I'm a moron, and I need to ask a non-moron some questions please!!!