Hi,
This is a formula that I am creating for a cell.
The system complains that there is an error on ISDATE (where I have indicated with below) :
How can this be solved please
Thanks
=IF(LOWER(E20)="ia-q",IF(ISDATE(D62),"YES",IF(LOWER(E20)="ia-r-q",IF(ISDATE(D62),"YES",IF(LOWER(E20)="ia-st",IF(ISDATE(D62),"YES",IF(LOWER(E20)="ia-lm",IF( ISDATE (D62),"YES", "NO"))))))))
error in formula
Latso
I believe the cause is the IF function, instead of ISDATE function. See below extracts from MS Excel help:
"Up to seven IF functions can be nested as value_if_true and value_if_false arguments to construct more elaborate tests. If you want to test more than seven conditions, consider using the LOOKUP, VLOOKUP, or HLOOKUP function. (See Example 4 for a sample of the LOOKUP function.) "
atzmon
What version of Excel are you using that you have an ISDATE() worksheet function Also, I don't think this is related to VBA. A general Excel forum would be a better place to find the answer.