conditional statement using validation cell


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.
 
Ad

Advertisements

L

Luke M

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

Then just copy down as needed.
 
Ad

Advertisements

K

kfarley537

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 ?????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top