How do I wrap the IF() to this function?

[hollyanneu2]

One of the cells has an #NUM! error. Should be 0.0%

This is the function: =([Total Sales] - [Total Sales DATEADD 1 Year Back])/[Total Sales DATEADD 1 Year Back]

Thank you.

 

[Joe4]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

This might be what you are looking for:

=IFERROR(([Total Sales] - [Total Sales DATEADD 1 Year Back])/[Total Sales DATEADD 1 Year Back],0)

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

If that is the formula with the error try

=IFERROR(([Total Sales] - [Total Sales DATEADD 1 Year Back])/[Total Sales DATEADD 1 Year Back],0)

 

[hollyanneu2]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

This might be what you are looking for:

=IFERROR(([Total Sales] - [Total Sales DATEADD 1 Year Back])/[Total Sales DATEADD 1 Year Back],0)

This works....I am using 365. I will update my profile. Thank you!

 

[Joe4]

You are welcome.
Glad we were able to help!