LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data validation error message not showing raphiel2063 Excel Worksheet Functions 1 November 9th 09 10:54 PM
MROUND error showing tcek Excel Worksheet Functions 7 January 15th 09 09:39 PM
copy of excel file not showing formulal/function in the function b oaallam Excel Discussion (Misc queries) 4 September 6th 07 01:20 PM
Showing Error when going to pass a function like this Brahmananda Mohanty Excel Worksheet Functions 1 May 6th 07 07:50 AM
How to print when an error message keeps showing? clueless Excel Discussion (Misc queries) 1 January 30th 06 05:33 PM


All times are GMT +1. The time now is 02:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"