issue with negative number in file

[drewszone32]

I have the following formula =IF(C46>0,SUM(C45-C46)/C45,0)


It works fine until I get across to cell I46 which is a negative number and comes up with 0.00%.


How do I fix this one?

 

[DaveTurton]

Is the cell formatted to percentage instead of number?

 

[drewszone32]

Yes, it is to calculate to a percent.

 

[DaveTurton]

then 0.00% is correct. You have said in your formula if the value of C46 is greater than 0 do the calculation else mark as 0

 

[drewszone32]

correct, I do I get it to calculate the negative numbers has well?

 

[Hui]

=(C45-C46)/C45

 

[DaveTurton]

Can you not just use

=SUM(C45-C46)/C45

?


If you are wanting to still calculate negative numbers I'm unsure as to why you are using the IF function

 

[drewszone32]

You are correct. thank you. over think sometimes...