Page 1 of 1
Negative equations
Posted: Thu May 30, 2002 6:41 pm
by Linda
Hi All,____I am trying to display a negative number in a formula. my formula goes like this: IIF(PRICE1=0,PRICE1*100,(PRICE1-COST1)/PRICE1)whichgive me 0%. I need it to display -100%. Is there any way to do this. I have tried everything.____Thanks in advance,____Linda:^(
=> RE: Negative equations
Posted: Fri May 31, 2002 1:02 pm
by ColinDow
IIF(PRICE1=0,PRICE1*100,(PRICE1-COST1)/PRICE1)____Not sure if I understood the question but if you want the answer to be -100% when price1 is zero would the formula not be more along the lines of____IIF(Price1=0,-1,(Price1-Cost1)/Price1)____If this is formatted on the display as a percentage then the display should be -100% when price1=0
==> RE: Negative equations
Posted: Mon Jun 17, 2002 4:28 pm
by Linda
Worked like a charm!____Thank You.:7