Forum Discussion

simonjudd's avatar
simonjudd
Copper Contributor
Feb 21, 2020
Solved

Need to split a figure across multiple rows, but not past 2 decimal places

Hi everyone,   We have a spreadsheet set-up for a financial return but we have an anomaly in it that I need to solve. Currently, we have a monthly figure (e.g. 116,391.62) that needs to be split a...
excel
Formulas and Functions
  • Savia's avatar
    Savia
    Feb 21, 2020
    I'd suggest using =ROUND(B$1/4, 2) or similar for the first three weeks, and then =$B1-SUM(B2:B4) for the bottom one.
Savia's avatar
Savia
Steel Contributor
Feb 21, 2020
I'd suggest using =ROUND(B$1/4, 2) or similar for the first three weeks, and then =$B1-SUM(B2:B4) for the bottom one.
  • simonjudd's avatar
    simonjudd
    Copper Contributor
    Feb 21, 2020

    Brilliant, thanksSavia