IF Function over sheets

[Bumblebee]

So i have a value (it is a percentage value %) that pulls from one sheet to another,
(exact formula below)
but if the value is 0, then it is blank, which is simple enough

=Binder!H26

but i want to just subtlety change it, so that if the value is 0, instead of being blank, it must display N/A

 

[NARAYANK991]

Hi ,

Can you not use an IF function , as in :

=IF(Binder!H26 = 0 , NA() , Binder!H26)

or

=IF(Binder!H26 = 0 , "N/A" , Binder!H26)

depending on whether you want the #N/A error value or a text string N/A.

Narayan

 

[Bumblebee]

that was perfect, i used the text string, thank you very much