If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculation Required
Hi All,
I need one of those phased calculations where the second part of a percent calc only comes in above a certain value. Is there a mathematic function that will ignore any number until it becomes positive so that I can simply use (x - y), rather than iif or something similar? Cheers. Bill. |
#2
|
|||
|
|||
Calculation Required
No. You'll need to use IIf.
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Bill" wrote in message ... Hi All, I need one of those phased calculations where the second part of a percent calc only comes in above a certain value. Is there a mathematic function that will ignore any number until it becomes positive so that I can simply use (x - y), rather than iif or something similar? Cheers. Bill. |
#3
|
|||
|
|||
Calculation Required
Blast!
Thanks. Bill |
Thread Tools | |
Display Modes | |
|
|