Weird Re-appearing Formula

**dfitz1000** · 04-30-2012, 08:17 PM

Hi, I'm making a spreadsheet where I can enter the shifts I work and it will calculate my shift rate multipliers.

In the attached spreadsheet cell F9 should be blank. Great, but the weird thing is when I fill in cells C6 to C9 with for instance an "E" for an early shift, a formula pops up in cell F9! It only happens when I fill in the shift for Tue, Wed, Thu and then Fri. I can't figure it out, hopefully somebody can take a look and help. I would like that F9 cell to remain blank.

Thanks in advance.

**scottylad2** · 04-30-2012, 09:30 PM

Can't replicate the error you're getting, when i enter C6-C9 with an E i'm getting nothing at all in F9

**dfitz1000** · 04-30-2012, 11:15 PM

Very strange, this is what I see. The box in red is the one I don't want and the formula that appears in it is as follows.

Please Login or Register  to view this content.

excel_screen.JPG

**scottylad2** · 05-03-2012, 07:30 AM

just delete the formula prior to adding any text in your shift column and save the sheet, shouldn't come back. Obviously there's been a formula there at some point

**dfitz1000** · 05-03-2012, 09:57 AM

That's the problem! The cell is blank, no formula entered there. Then when I fill in the shift column, the formula appears there.

**JosephP** · 05-03-2012, 10:03 AM

it's being filled from the cell above. do you have 'extend data range formats and formulas' checked in Options under the Advanced section?

**dfitz1000** · 05-03-2012, 10:55 AM

Yes! Thank you, that has sorted it! How did you know it was being filled from the cell above? And what is the purpose of this extend data range option? Thanks for your help guys.