Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data validation error message not showing | Excel Worksheet Functions | |||
MROUND error showing | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
Showing Error when going to pass a function like this | Excel Worksheet Functions | |||
How to print when an error message keeps showing? | Excel Discussion (Misc queries) |