Hi all!
1st post, so I hope I got it in the right section :D
I'm having some problems getting my whole formula to be recognised by Excel.
What I have got is:
=IF(COUNT(E2),IF(SUM(E2)<=40.05,"Pass","Fail"),"enter data"
basically, telling the sheet to put a Pass/Fail if it meets/doesn't meet this criteria.
What I need to have also is a formula telling this formula that if it is a Pass under 10 seconds that it needs to say "Null" or "Invalid". I have tried entering this myself but it always shows up as 'my argument is too long'
Is there a way of telling the formula to do this or would I need to dip inside VB Editor (not my greatest skill) in Excel for this?
Any help greatly appreciated
Bookmarks