Calculate percent required to achieve target number

[KelMacch]

Hi,

My name is Kellie and I am new to this forum.

I am trying to teach myself how to use Excel, however finding the calculations quite hard.

If anyone would be able to help me with the below, it would be greatly appreciated!!


Column F is the actual target, Column G is the sales for April and Column H will be the sales for May.

I know need to try work out the percent % which remains to reach the target for each store- Column I.

Thanks!!

 

[Simon4s]

Hi,

My name is Kellie and I am new to this forum.

I am trying to teach myself how to use Excel, however finding the calculations quite hard.

If anyone would be able to help me with the below, it would be greatly appreciated!!


Column F is the actual target, Column G is the sales for April and Column H will be the sales for May.

I know need to try work out the percent % which remains to reach the target for each store- Column I.

In cell I2, type =IF(F2>G2,1-G2/F2,"goal reached")

Right click i2, >format> percent