Amend formula to remove #VALUE! from result
Hi,
can any please advise of the syntax I need to amend the following formula (which is in cell 'T2')
=IF(ISNA(A4),"",IF(AND(S4="Not Due",$F$1-K4>0),"Missed",S4))
to check if cell 'K2' is empty, and if so display 'T2' as blank rather than have 'T2' as #VALUE!
Many thanks in advance
Regards
Rob
Rob
The fault is probably F1-K4, one of them is probably text.
Use ISTEXT/ISNUMBER to test values.
You should also rectify the error at A4
in A4
=IFERROR(formula,"",formula)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
What results could A4 be showing?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks