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.
 

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

Similar Threads

data validation list 17
Data Validation and drop-down list using IF, AND and what else? 8
If formula and Data Validation parallely 1
Figuring out a lengthy formula. Probably quite simple... 3
Looking formula that SUM values with specific value in neighboring colum 2
SUM - IF - AND 7
Excel Formula Help 2
counting formula 3

Back
Top