I have had to amend my model slightly and now my sumproduct formula isn’t working.
In cell C10 of the sheet “FDQM Load 11” it should be picking up the value of £500 from cell R10 of the sheet “P&L Walk”
Why isn’t it working?
Is there a work around as i can not change the format?
Hi.
You have a #VALUE! error in cell D524.
Your IFERROR is not acting on each individual value in the array being passed to SUMPRODUCT, if that's what you were intending, but on the overall result of that function.
Regards
Ah - just spotted that also.
I need to change:
=IF(COUNT(FIND({0,1,2,3,4,5,6,7,8,9},E524)),VALUE(RIGHT(E524,6)),E524)
Can it be amended so if the first two letters are both text then if true, then do the above (IF(COUNT(FIND({0,1,2,3,4,5,6,7,8,9},E524)),VALUE(RIGHT(E524,6)),E524)) if not then just E524
Is that possible?
And what if both of the first two letters are not text?
Regards
That shouldnt happen at all.
But then why have an IF statement to that effect if only one outcome is possible?
Regards
Hi,
Its a safety precaution, to my knowledge there are no others but their might be in future
Perhaps you can adapt the following, generic formula to meet your needs, which will return TRUE if the first two characters from the string in A1 are non-numeric, and FALSE otherwise:
=COUNT(0+MID(A1,{1,2},1))=0
Of course, if the string can be of length less than two characters, then this will require an additional clause, otherwise it may give incorrect results.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks