K
kfarley537
I need help on writing this function that uses a value from a drop down menu
created with Data/Validation menu items.
D column has pull down menu of either 'Bought' or 'Sold' created on sheet 2
named Action by Data then Validation menu item.
Im trying to keep track of stocks. I Have I and J columns resulting in
values .
In the I column for each row i want to use something like
if D6 is Bought then (f6*G6)+H6 and I want the value to be place into I6 if
the value in D6 is Sold then i want J6 to show the result of f6*g6+h7
I6 is named total out and J6 is named total in.
This would be the same for rows 4 thru 37 so far. So insted of the 6
wahtever row number would replace that 6
ie. for F row the I12 cell would read
If D12 is bought then (f12*g12)+h12 else place this value into J12
I hope this would be easiest way to get my values. Any help is greatly
appreciated.
created with Data/Validation menu items.
D column has pull down menu of either 'Bought' or 'Sold' created on sheet 2
named Action by Data then Validation menu item.
Im trying to keep track of stocks. I Have I and J columns resulting in
values .
In the I column for each row i want to use something like
if D6 is Bought then (f6*G6)+H6 and I want the value to be place into I6 if
the value in D6 is Sold then i want J6 to show the result of f6*g6+h7
I6 is named total out and J6 is named total in.
This would be the same for rows 4 thru 37 so far. So insted of the 6
wahtever row number would replace that 6
ie. for F row the I12 cell would read
If D12 is bought then (f12*g12)+h12 else place this value into J12
I hope this would be easiest way to get my values. Any help is greatly
appreciated.