Registered User Joined: 10/14/2010 Posts: 55
|
Hi,
Is it possible to write a condition like this?
C >= H1 - $0.??
I know I can do it as a percentage
C >= .98 * H1
Thanks,
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Sure. You even have the syntax almost exactly right. You just need to drop the $ sign.
C >= H1 - .05
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 10/14/2010 Posts: 55
|
Thank you Bruce. This is going to save me a bunch of time.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|