Formula

[aparvez007]

Hi Ninjas,


i want formula which give 0% if any of one value is zero...


=IF(ISERROR(ROUND(D5/C5,2)*100 & "% " & IF(D5>C5,"▲", IF(D5=C5,"●","▼"))),0)


I use above formula but not working for both condition.


Example


A2 B2 C2

1200 0 0%▼

0 1200 0%▼


Thanks Nijas...

 

[Luke M]

How's this?

=IF(OR(C5=0,D5=0),0&"%",ROUND(D5/C5,2)*100 & "% " & IF(D5>C5,"▲", IF(D5=C5,"●","▼")))

 

[aparvez007]

Luke the real Ninja....


It's work fine...


Thanks alot Luke the Ninja...

 

[Luke M]

Always glad to help. Thanks for the kind words. =)