Hi Guys,
I have this formula as for example '=N4/N3', I would like to add in if both cells are '0' then show as "n/a" rather than an error which is what i currently have,
thanks
Hi Guys,
I have this formula as for example '=N4/N3', I would like to add in if both cells are '0' then show as "n/a" rather than an error which is what i currently have,
thanks
=if(n4+n3,n4/n3,"n/a")
try thia
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Thats great thanks!
thank you isolation123 for your feedback and adding reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks