View Full Version : Solved: Apportioning Query
parttime_guy
08-30-2007, 07:49 PM
Is there a better way of apportioning.
Thx-n-BR
mdmackillop
08-30-2007, 11:23 PM
Define "better"
parttime_guy
08-31-2007, 07:13 PM
Hi mdmackilliop,
Thx MD for showing interest!
"Better", I mean to say if the results in Column H ("Balance Gain") can be arrived with a single formula.
Best regards,
parttime_guy
anandbohra
08-31-2007, 11:39 PM
here is the formula
use when your loss amt is negative
type this in Cell H5
=D5+(D5*$E$10/$D$10)
use this when u write loss in absolute terms (possitive)
type this in Cell H5
=D5-(D5*$E$10/$D$10)
parttime_guy
09-05-2007, 07:33 PM
Thanks Anand, ur formula works well, problem solved! Best regards. :thumb :friends:
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.