If YTD I have 300 and LYTD 0 and I need to know the % of increase or decrease
the answer is or not? 30000% %CHANGE
Thanks for your help again


"CLR" wrote:

The "blank" return in the case of a 0 in B1 is intentionally coded into the
formula with the "" part.....what would you like to have as a return when
B1=0?......if you want zero, then replace the "" with 0, as
=IF(B1=0,0,(A1-B1)/ABS(B1))
If you prefer some TEXT result, place it between the "", as
=IF(B1=0,"PutTextHere",(A1-B1)/ABS(B1))

hth
Vaya con Dios,
Chuck, CABGx3


"Nectar" wrote:


"CLR" wrote:

=IF(B1=0,"",(A1-B1)/ABS(B1))

Vaya con Dios,
Chuck, CABGx3


HI Chuck Thanks a lot for your help
I'm getting a error, the formula work but went it a zero for LYTD nothing
comes up in my cell is in blank Any suggestions?
YTD 500 LYTD 0 =500% suppose to have 500%
"Nectar" wrote:

PLease help i'm trying to set up my worksheet to calculate the increase or
decrease percentage from YTDr to LYTD

YTD= 200 LYTD=145 =.38% formula =(a1-b1)/abs(b1) but when I have a zero my
formula wont work please help me to create a formula that could work with
zeros

Thanks a lot my saviors !!!!