#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Nevermind, I got it to work flawlessly using some max/mins =)
|
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 |
IF statement that adds text to a cell | themangoagent | Mail Merge | 4 | 08-26-2009 08:07 AM |
Vlookup and If statement problem | bunnygum | Excel | 1 | 03-24-2009 05:10 AM |