Hi,
I am trying to work on a Forecast spreadsheet. I have in column E my new forecast for Q3.
In Column I, I have my Q1 Actuals. In column M I have the difference between the Forecast for Q3 and the Actuals for Q1. In column N I have my Q2 Actuals. In column O I have the difference between the forecast for Q3 and the Actuals for Q2.
In Column P I am trying to put a % variance based on if a figure is up or down comparing Columns M and E.
In Column Q I am trying to put a % variance based on if a figure is up or down comparing Columns O and E.
I have a formula that states this =M14/E14
And then I treid =IFERROR(IF(AND(I27=0,E27>0),-1,M27/I27),0)
This works fine in general. The problem is when one number is a negative and one a positive.
Is there a way around. I have read about ABS, but can’t get it to work.
If I can explain better please let me know, just want to get something in before we go on lockdown!
Kind regards,
James
I am trying to work on a Forecast spreadsheet. I have in column E my new forecast for Q3.
In Column I, I have my Q1 Actuals. In column M I have the difference between the Forecast for Q3 and the Actuals for Q1. In column N I have my Q2 Actuals. In column O I have the difference between the forecast for Q3 and the Actuals for Q2.
In Column P I am trying to put a % variance based on if a figure is up or down comparing Columns M and E.
In Column Q I am trying to put a % variance based on if a figure is up or down comparing Columns O and E.
I have a formula that states this =M14/E14
And then I treid =IFERROR(IF(AND(I27=0,E27>0),-1,M27/I27),0)
This works fine in general. The problem is when one number is a negative and one a positive.
Is there a way around. I have read about ABS, but can’t get it to work.
If I can explain better please let me know, just want to get something in before we go on lockdown!
Kind regards,
James