View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vijay[_3_] vijay[_3_] is offline
external usenet poster
 
Posts: 21
Default Error showing up as #VALUE! in if function

Hi,

I have given Function =IF(G931,G93+14,IF(G93<1," ")) in Column G,H,I & J
what happen is, if the date is there in the column F then everything is ok,
(As all the Column G,H,I & J are related to each other whereas the column G
is related to column F)
but the problem is when the date is not in Column F then the Column H,I & J
shows up and error as #VALUE!.
What I want is even if the date is not there in column F the Column H,I & J
should not show up the error #VALUE
Please help
--
vijay