Thread: Turning #value into a blank cell
View Single Post
  #2   Report Post  
Jimmystix Jimmystix is offline
Junior Member
  
Posts: 2
Default
Quote:
Originally Posted by amik View Post
I have this formula A5/b5-1

Somtimes due to a pivot table there will be no numbers in the A5 and B5.
Curently it gives mea #value. is there a way to get this to be blank?

I would appreciate any help
use an IF combined with an ISERROR so it should read =IF(ISERROR(A5/B5-1),"",A5/B5-1)
Reply With QuoteReply With Quote