conditional statement using validation cell
 

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.

conditional statement using validation cell
 

In column I:
=IF(D4="Bought",F6*G6+H6,"")
In column J,
=IF(D4="Sold",F6*G6+H6,"")

Then just copy down as needed.
--
Best Regards,

Luke M


"kfarley537" wrote:

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.

conditional statement using validation cell
 

Ok so there is no way to place information in column I that would place
information into column J if the value in I is false?
+If(D4="Bought",R6*G6+H6,"")else J4=r6*g6+h6 ?????

"Luke M" wrote:

In column I:
=IF(D4="Bought",F6*G6+H6,"")
In column J,
=IF(D4="Sold",F6*G6+H6,"")

Then just copy down as needed.
--
Best Regards,

Luke M


"kfarley537" wrote:

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.