Drop down field

  • Thread starter Thread starter anonymous
  • Start date Start date
A

anonymous

I am trying to have a field to recognize that when one of
the option of the drop down list is selected (I have many
row with a drop down field) it will automatically deduct
the amount of the cell next to it from the grand total?
Has anyone an idea?

Thanks
 
Hi

what's the cell reference & formula for your grand total and what's the cell
reference of the drop down field (or one of them) and the cell reference of
the cell next to it?

Cheers
JulieD
 
Allo Julie,

My drop down field source is BA1:BA9 (I have 8 options
which the first one is blank)

The drop down field is located on G8 then G11 then G14 and
so forth (every 3 rows)
The cell reference next to drop down field that have the
amount that needs to be deducted is M10 then M13 then M16
(every 3 rows also)and so forth
My grand total cells reference are D307 (for option 1)
then E307 (for Option 2) then F307 (for Option 3) and so
forth. My formula that I have used is =IF(G8=BA2,D307-
M10,0). The problem is this formula work for only one
option and one cell reference. I want it to deduct the
amount (which will be in colum M) of a new entry that is
made and an new option (which would be on another row)
when selected, from their related Grand total.

I hope that you understand what I am trying to say.

Merci
 
Allo Julie,

My drop down field source is BA1:BA9 (I have 8 options
which the first one is blank)

The drop down field is located on G8 then G11 then G14 and
so forth (every 3 rows)
The cell reference next to drop down field that have the
amount that needs to be deducted is M10 then M13 then M16
(every 3 rows also)and so forth
My grand total cells reference are D307 (for option 1)
then E307 (for Option 2) then F307 (for Option 3) and so
forth. My formula that I have used is =IF(G8=BA2,D307-
M10,0). The problem is this formula work for only one
option and one cell reference. I want it to deduct the
amount (which will be in colum M) of a new entry that is
made and an new option (which would be on another row)
when selected, from their related Grand total.

I hope that you understand what I am trying to say.

Merci
Click to expand...

---snip ---
Hi

if i'm understanding you correctly, how about changing your formula to
=IF(G8="",0,D307-M8)
not sure how you can do it automatically for all the other options as they
are down a column but you want the total to increment across a row

let me know
Cheers
JulieD
 
I am thinking more about IF(G8:G304=1,D307-"").

It is very difficult for me to write this formula. The
logic of it is I want every rows that are selected,lets
say, with the option 1, the amount attached to it which
would be on column M, will be deducted from the Grand
total.(D307) And the same for all the other option.

I understand the logic but don't seem able to put it in
formula. I hope very hard that you can help me.

Thank you so much for all your help.
 
Back
Top