1. A1=10, A2=20, A3=30...A10=100
2. C1=5
3. In column B I want to multiply each number in column A by C1
4. In B1 I enter "=A1*$C$1"
5. In B1 "30" appears as expected. But when I click and drag the fill handle to B2-B10, "30" also appears in all those cells as if I had copied the formula without conditionally formatting C1.

This has worked as it should in the past, so I am not sure what is wrong. I am using Excel 2016 in Windows 10. I tried the same thing in another workbook without luck.



Anyone able to tell me what might be wrong? Thanks!

Is calculation set to manual?

If A1 is 10 and C1 is 5, A1*C1 should be 50 not 30???

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post