You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Problem: Column A contains a generated number of sq inches for each object(variable), A cell(A50) contains the price/sq inch(not variable). In the new column F each row needs a formula Column A * A50. All I can get when I Fill Down is the first Row *A50, the second Row*A51, third Row *A51, etc., etc. What is the correct formula to just Fill Down the row and get each to multiply with the none-variable number. Thanks.
iMac 24″, macOS 14.5
Assuming your values in column A start at row 2, then in F2 use the formula:
=A2*A$50.
Fill that down the column.
Note the $ anchor, most easily entered by checking Preserve Row.
SG
How to use a none-variable cell as a multiplier?
