Formula Not Reading Cell Data Correctly

Hi there,

I have a somewhat strange situation where formulas that are linked to Cell C5 on my 'Inspection Report' sheet aren't reading it correctly. I've attached a sample with the linked cells in yellow, and here is a basic description of how it should be working:

Cell C5 on the Entry Page sheet receives a number. (In our case, 22.) Cell C5 on the Inspection Report sheet now displays 22, which is great - but notice Cell S7 - this is only supposed to appear if C5 is greater than 49, but it's appearing at 22. And upon visiting the Inspection Report Attachment sheet, we see that Cell R1 displays 3, which is specified in it's formula only to show a 3 if Cell C5 on the Inspection Report is greater than 160. The columns of numbers are also linked to Cell C5 on the Inspection Report sheet and are also not displaying correctly.

I have noticed that if I enter a number in Cell I8 on the Entry Page sheet (which is sometimes required, but not always), everything works like it should.

I've been scratching my head for a while here, does anyone know what's going on?

NOTE: A 'run-time' error will pop up upon opening the workbook - just click 'End' - this is only because this is a sample with sheets missing.

Hi

I think...

In Entrypage! C5, change the format from text to number....

Haha! Wow! I'm glad it was so simple! Thank you so much, Fotis1991!

..Simple is good my friend!

Oops, I've found an issue I missed - when I changed the format of Cell C5 on the Entry page from text to number, it fixed everything except this: when I delete C5 on the Entry Page, the yellow columns on the Inspection Report Attachment all get numbers, due to the formula in Cell A6 on that sheet. Why isn't that formula working?

Hi

Problem is here(Red color)--Inpection report C5.

=IF(AND('Entry Page'!$I$8>0; 'Entry Page'!$I$8<>0);('Entry Page'!$I$8*'Entry Page'!$C$5);('Entry Page'!$C$5))

This "says" that if "Entry Page!I8>or <>(DIFFERENT) TO 0,then I8*C5(in this case) 0*0 OR C5. That is, O

Apologize for my poor English..

Ah, and 0 is counted as an entry then? Would there be a different way of saying this on Cell A6 on the Inspection Report Attachment ?: =IF('Inspection Report'!$C$5="","","1")

I've been trying to do something with =IF(COUNTBLANK('Inspection Report'!$C$5)=0,"","1"), but that doesn't seem to work properly either.

And your English isn't poor at all, it's my Greek that isn't any good.

..So, my friend, it's All Greeks to you...

Pls, explain me, in Inspection Report M7-M8 etc..Why and by which conditions do you need these texts to dissapear..

Haha, I guess it is.

Those cells (M7 -V8) are working now since your first fix, these are no longer a problem - but since you asked, the first two (M7 & M8) are only needed to display their data when Cell C5 is greater than 1, P7 & P8 when C5 is greater than 19, S7 & S8 when C5 is greater than 49, and V7 & V8 when C5 is greater than 99. This is because the quantity determines how many samples we need, so having them automatically hide and appear is very useful to us.

The cells I'm having trouble with are the 6 yellow columns on the Inspection Report Attachment - they represent each individual part, so there must not be any numbers there if Cell C5 on the Inspection Report Attachment is empty - likewise, they must appear when a number is in Cell C5, but only the amount that is entered in that cell.

Doesn't changing A6 to:

=IF('Inspection Report'!$C$5=0,"","1")

work.

Btw, the 1 shouldn't reallly by in quotes if you want it to be a real number

e.g.

=IF('Inspection Report'!$C$5=0,"",1)

also formula in Inspection Report, C5 should be:

=IF('Entry Page'!$I$8>0,'Entry Page'!$I$8*'Entry Page'!$C$5,'Entry Page'!$C$5)

i.e. if I8 is greater than 0, then it won't be equal to 0...

Yes! That does it! I attached the working sample. Thank you so much, both of you.