Hello,
it might be a simple question for most of you but, when I try to retrive data I sometimes get the following errors like
#DIV/O! or #N/A
those are apparering in case like
=HPVAL(F10, B94, F9, F7, F8) or even simplier cases like 0 minus 0 !!!
is there a way to ignore them automatically from options or an if function so that if data cannot be calculated or retrived simply fill the cell with '0'
it might be a simple question for most of you but, when I try to retrive data I sometimes get the following errors like
#DIV/O! or #N/A
those are apparering in case like
=HPVAL(F10, B94, F9, F7, F8) or even simplier cases like 0 minus 0 !!!
is there a way to ignore them automatically from options or an if function so that if data cannot be calculated or retrived simply fill the cell with '0'