Can anyone explain how I can add a rounding formula to the formulas created in the subtotal fetaure? i.e. when I apply subtotal, the formula created in the subtotal line is =subtotal(9,e1:e100) - but I need to have that rounded to the nearest 100 so I would like it to read =round(subtotal(9,e1:e100)-2). I have numerous rows and don't want to edit each individually
My other option is to combine the two formulas from different cells in a third cell, similar to the concatenate function but with formulas. Is this possible too?
Thanks
My other option is to combine the two formulas from different cells in a third cell, similar to the concatenate function but with formulas. Is this possible too?
Thanks