Constant in formula
Solved/Closed
John
-
Dec 1, 2009 at 09:56 PM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Dec 2, 2009 at 06:08 AM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Dec 2, 2009 at 06:08 AM
Related:
- Constant in formula
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Cardtext formula in word - Guide
1 response
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491
Dec 2, 2009 at 06:08 AM
Dec 2, 2009 at 06:08 AM
Hello,
You have to put a $ between the B and 1 to fix the cell thus your formula become :
=ROUNDDOWN(SUM(A1*B$1),2)
Best regards
You have to put a $ between the B and 1 to fix the cell thus your formula become :
=ROUNDDOWN(SUM(A1*B$1),2)
Best regards