Is there a better formula that will calculate the % comparisons between one year & the other's finances - alongside getting the formula box to show '0.00%' rather than the '#DIV/0/' when there is no revenue to compare in the revenue columns please?
Is there a better formula that will calculate the % comparisons between one year & the other's finances - alongside getting the formula box to show '0.00%' rather than the '#DIV/0/' when there is no revenue to compare in the revenue columns please?
Try
D3Formula:Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
I knew it would be a simple If formula, & I did it as =IF(B3="","",(C3/B3)/B3), but it didn't like that. So thanks very much.
"" double quote means is text whereas in your condition there are numbers..
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks