YTD Sales Comparison vs Last Year and vs Target Error

Dear All,

I would like to seek your assistance please on how to correct a formula I previously made in computing YTD Sales and comparing it with Previous Year and Target.

The idea is for the sheet to automatically compute or update once actual 2019 Sales is inputed, but I am getting an error whenever the sales is negative or reflects a zero number.

Please see attached excel sheet for reference.

I have already tried several options but I cant seem to figure our, realistically we get negative or zero sales due to client returns, which is why it is important for us to capture this as well.

Hoping for your kind assistance.

Sincerely,

Francis

Hi Bebo,

Thanks for the response. I am sharing the picture with the desired outcome (my apologies I dont know why I cant upload the excel sheet), hoping someone can help me.

Regards - Francis

Attachment 626299

Hi AliG

Thank you for your guidance, following your instructions I was able to attach the excel.

The desired outcome is hard coded so it was able to compute for negative values, if you will compare with the previous (above) examples wherein the formula only computes for positive values.

Much gratitude, francis.

Hope someone can help me figure how i can correct the formula. Thank you.

Francis