Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-12-2010, 07:50 AM
CPelkey CPelkey is offline Help with IF statement! Windows XP Help with IF statement! Office 2003
Novice
Help with IF statement!
 
Join Date: Apr 2010
Posts: 6
CPelkey is on a distinguished road
Question Help with IF statement!

I have a form where a user enters the number of reports for the current year and the previous year. Based on these inputs, I need to say that there was either an increase or decrease of x% from the previous year.



I already set up an IF statement which writes "increase" or "decrease" based on the inputs, but for some reason I am having trouble getting the percentage to work. The formula for the precentage will be different depending on if the total number of reports has increased or decreased. Here is the IF statement I am having problems with:

{ =IF(RepTotal>PrevYearRep PrevYear/RepTotal RepTotal/PrevYear \# "0%" }

Where "RepTotal" is the number of reports for the current year, and "PrevYearRep" is the number of reports from the previous year.

It doesn't give me any kind of error, it just disappears with no output when I click toggle or update field.

What did I do wrong, and how do I make it work?

Please help
Reply With Quote
  #2  
Old 04-12-2010, 09:06 AM
CPelkey CPelkey is offline Help with IF statement! Windows XP Help with IF statement! Office 2003
Novice
Help with IF statement!
 
Join Date: Apr 2010
Posts: 6
CPelkey is on a distinguished road
Default

Nevermind, I got it to work flawlessly using some max/mins =)
Reply With Quote
Reply

Tags
field codes, form fields, if statement

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Have you seen this error statement? nebb Word 4 12-01-2009 10:05 AM
Help with IF statement! IF statement that adds text to a cell themangoagent Mail Merge 4 08-26-2009 08:07 AM
Help with IF statement! Vlookup and If statement problem bunnygum Excel 1 03-24-2009 05:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft