I think B4 is the problem - how did u format the ()?


"PA" skrev:

Col"A" B C D E F

Y1 Y2 Y3 Y4 Y1-Y4
Revenue (13) (4) - 1 #NUM!


Dear All, I try to use function =Rate to Calculate % at cell F4
Cell F4 =IF(E4=0,0,RATE(3,,-1,((+E4-B4)/B4)+1))
The Result is #Num!.

Appreciate anyone can help with modify formula on this?

Many Thanks & Best Regards

PA