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.
Easy Bake. Flop-a-palooza. Woosh. Pop. I don't skulk.
Angel ,'Shells'
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: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.
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!!!
DXMachina - Oct 06, 2006 4:44:45 pm PDT #9152 of 10003
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
Hey, there!
Cybervixen - Oct 06, 2006 4:45:12 pm PDT #9153 of 10003
Queen of the Drive-By
HI!!!!!!!!!! How are you DX???