AgTalk Home
AgTalk Home
Search Forums | Classifieds (25) | Skins | Language
You are logged in as a guest. ( logon | register )

excel question.
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
torn
Posted 2/19/2015 19:43 (#4399185 - in reply to #4399019)
Subject: RE: Some pics


roaming
WTXCottonguy - 2/19/2015 17:49

Don't laugh I had to use my phone to get a screen shot. I know how to get it to reference a cell, this is a step farther. What I want is when I select Corn from my drop down box I want it to reference the cell with the price I have for corn, then when I change that box to cotton I want it to automatically references the cell with the price I have for cotton does that make any more sense? This is different than just making one cell equal another it making one cell equal another when the first cell is changed to whatever is in my drop down box. I have to keep my Drop down box becasue that's what I use to reference my variable expenses.

There may be an easier/different/better way, but you could do it with an "if" statement. Would look something like "if $cell = "Cotton", referenceTheCottonPriceCell). You can nest the if statements to check for different conditions. A quick Google search on "Excel if statements" should get you started.
Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)