MrExcel Publishing
Your One Stop for Excel Tips & Solutions

if then functions

Posted by Art on January 07, 2002 4:51 PM

I am trying to set up a database that lists information for a particular subject buy row, but is broken down by a variety of categorys.

I would like to enter certain criteria and have certain numbers based on that enter criteria pop up in selected cells.

I think that this is an if then function but I am not sure.

Posted by Jacob on January 07, 2002 5:01 PM


You can do this with userforms or validation. validation is easier for beginners so thats what Ill post. Lets say the date|validation for col B is Z1:Z50 then what we have to do is change the values in col z. So in col z1:z100 put =if("A1" = 1,"a",if("A1" = 2,"b",if("A1")=3,"c","")))

This will change the validation based on the value in col A