Negative equations

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Linda
Posts: 17
Joined: Tue Oct 10, 2017 12:44 pm

Negative equations

Post by Linda » Thu May 30, 2002 6:41 pm

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:^(
Top
ColinDow
Posts: 39
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Negative equations

Post by ColinDow » Fri May 31, 2002 1:02 pm

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
Top
Linda
Posts: 17
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Negative equations

Post by Linda » Mon Jun 17, 2002 4:28 pm

Worked like a charm!____Thank You.:7
Top
Post Reply

Return to “R&R ReportWorks Users”