IF Formula to Dada Validation

  • Thread starter Thread starter Excel_Oz
  • Start date Start date
E

Excel_Oz

Hi All,

I want to get across the following:

I have dropdown list in colum A and in column b some information. In
coulum c I want to say (if the word in column a equals "fortnightly",
then multiply B and another cell)

For some reason it is not allowing me to put an if sum using the drop
down list.

Can someone help?

Thanks!
 
Hi All,

I want to get across the following:

I have dropdown list in colum A and in column b some information. In
coulum c I want to say (if the word in column a equals "fortnightly",
then multiply B and another cell)

For some reason it is not allowing me to put an if sum using the drop
down list.

Can someone help?

Thanks!
Click to expand...

Nevermind... excel was just playing up.
 
Back
Top