View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arthur Arthur is offline
external usenet poster
 
Posts: 18
Default How do I avoid repeating calculation in IF function?

I use a calculation that sometimes (legitimately) returns the error code
#N/A. When this happens, I want a blank stored in the cell. So:
IF(ISNA(calculation),"",calculation)
Is there some way of avoiding the second calculation?