Thread: % calculations
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default % calculations
"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".
Reply With QuoteReply With Quote