Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
A particular formula sometimes generates an #N/A result (because of some
missing data elsewhere in the spreadsheet). I want to be able to replace the #N/A with a more helpful error message eg : IF((A1*A2)/A3="#N/A","Missing Data",A1/A2) Can some SKS give me the correct syntax to do it. TIA Rob |