condition formatting for a text control containing a formula

G

Guest

Hi, I have a text control in my report in which i want to calculate
percentage increase of revenue from year to year, so my formula would be
something like (revnue of year2/revenue of year1)-1.
Now I got #div/0! or #Num! for those that the formula gets to divide by 0.
Is there a way that I could set where the result is invalid to appear as N/A
or something more making sense? Thanks.
 
V

Van T. Dinh

Try something like:

= IIf([revenue of year1] = 0, "N/A", ([revnue of year2]/[revenue of
year1])-1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need a formula to calculate Average Sales Commission 2
Use of text and calculation in a formula 2
Searching the formula (not the value) for a text string 1
Average formula only works partially..... 6
A clever formula req for lead time revenue calc 7
Formula for a sum 4
Creating a formula for sales comparison spreadsheet 4
Identify month in a period and run a formula 4

Top