Why does this happen?

[Mathman]

I have a formulae that if its doesn't meet certain conditions that it returns a blank ,"")


the odd thing is as I run the loop and collect the data with each passing by a simple equal equation if the cell was blank it returns an apostrophe in the cell like this '




Any idea as to why this is happening?


Thank you,
MM​

 

[My Aswer Is This]

Are you talking about a Vba script or a formula:
You said:

have a formulae​

But then said:

as I run the loop ​

I did not know formulas could run loops.


Either way you need to show us the formula or the Vba script.

 

[Mathman]

This is the formulae

=IF(FX$1<=IFERROR(IF(SUMIF($DB$3:$DB$52,DO$2,$DG$3:$DG$52)/IF(SUM(DO$37/10)*SUMIF('A1_Filter Horizontal'!$D$4:$D$355,$FV3,'A1_Filter Horizontal'!E$4:E$355)<$DE$2,MROUND(SUM(DO$37/10)*SUMIF('A1_Filter Horizontal'!$D$4:$D$355,$FV3,'A1_Filter Horizontal'!E$4:E$355),0.005),ROUND(SUM(DO$37/10)*SUMIF('A1_Filter Horizontal'!$D$4:$D$355,$FV3,'A1_Filter Horizontal'!E$4:E$355),2))-1+SUMIF('A1_Filter Horizontal'!$D$4:$D$355,$FV3,'A1_Filter Horizontal'!E$4:E$355)/10000000>0%,IF(SUM(DO$37/10)*SUMIF('A1_Filter Horizontal'!$D$4:$D$355,$FV3,'A1_Filter Horizontal'!E$4:E$355)<$DE$2,MROUND(SUM(DO$37/10)*SUMIF('A1_Filter Horizontal'!$D$4:$D$355,$FV3,'A1_Filter Horizontal'!E$4:E$355),0.005),ROUND(SUM(DO$37/10)*SUMIF('A1_Filter Horizontal'!$D$4:$D$355,$FV3,'A1_Filter Horizontal'!E$4:E$355),2)),SUMIF($DB$3:$DB$52,DO$2,$DG$3:$DG$52)),""),IFERROR(IF(SUMIF($DB$3:$DB$52,DO$2,$DG$3:$DG$52)/IF(SUM(DO$37/10)*SUMIF('A1_Filter Horizontal'!$D$4:$D$355,$FV3,'A1_Filter Horizontal'!E$4:E$355)<$DE$2,MROUND(SUM(DO$37/10)*SUMIF('A1_Filter Horizontal'!$D$4:$D$355,$FV3,'A1_Filter Horizontal'!E$4:E$355),0.005),ROUND(SUM(DO$37/10)*SUMIF('A1_Filter Horizontal'!$D$4:$D$355,$FV3,'A1_Filter Horizontal'!E$4:E$355),2))-1+SUMIF('A1_Filter Horizontal'!$D$4:$D$355,$FV3,'A1_Filter Horizontal'!E$4:E$355)/10000000>0%,IF(SUM(DO$37/10)*SUMIF('A1_Filter Horizontal'!$D$4:$D$355,$FV3,'A1_Filter Horizontal'!E$4:E$355)<$DE$2,MROUND(SUM(DO$37/10)*SUMIF('A1_Filter Horizontal'!$D$4:$D$355,$FV3,'A1_Filter Horizontal'!E$4:E$355),0.005),ROUND(SUM(DO$37/10)*SUMIF('A1_Filter Horizontal'!$D$4:$D$355,$FV3,'A1_Filter Horizontal'!E$4:E$355),2)),SUMIF($DB$3:$DB$52,DO$2,$DG$3:$DG$52)),""),"")

I then use this formulae to get this data to enter in into a separate sheet.

=INDEX(Index_Testing_Results,N$4,D$1)

The the result is blank I get ' in the cell.......

 

[My Aswer Is This]

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.