"Roger Govier" wrote:
> Assuming your real data is in A1 and your budget in B1
> then enter in C1 =IF(B1<1,"Not Applicable",A1/B1)

I think the condition should be "B1 <= 0".