Expression Help?

[sandingdude]

What would the expression be if I wanted to see if a value I computed is greater than or equal to .25. If its true I need it to say Pay Rebate and if its is false I need it say No Rebate.


This is my statement now:

=IIf((1)-([QTY]*[Cost])/([QTY]*[Price])>=".25","Pay Rebate","No Rebate&quot

The "No Rebate" is not working.

Please help.

Thanks in advance.

Dave

 

[hneal98]

=IIf((1)-([QTY]*[Cost])/([QTY]*[Price])>= .25 ,"Pay Rebate","No Rebate&quot


Removed the quotes from ".25", should be .25. Also, just a thought, you understand that you are subtracting ([QTY]*[Cost])/([QTY]*[Price]) from 1? Is that what you wanted?

 

[sandingdude]

hneal98

thanks it worked! i need to subtract from 1 to get the gross margin. beacuase the value i compute is usually like .88 and i have to subtract that from 1 to get the gross margin. thanks for your help.

dave

 

[hneal98]

no problem. glad i could help.