If/then Formulaes

zstein · Dec 14th 2005

I need to create a formula that will pull data from one worksheet into another worskheet, but with some very specific parameters:

1. It must first check the STATUS column, and if the word SOLD is there, it will check for the next parameter. If the cell is blank, it will know that this line of data is not required and not pull it.
2. If the previous function found the word SOLD, then the formula goes to the BILLED column, and checks to see if the cell is blank. If it is not blank, it will know that this line of dat is not requred and not pull it. However, IF there is data in this cell, it will pull all the information from this row into the other worksheet.

I hope that is clear.

Zane

carlmack · Dec 14th 2005

Re: If/then Formulaes

Zane,

Welcome to Ozgrid.

Unfortunately I think you have posted in the wrong forum.

Hopefully somebody will move it for you.

Anyway whilst I am here .. I would suggest looking at advanced filter under the data menu first.

I am attaching an example. If you get stuck post back.

**royUK** · Dec 15th 2005

Re: If/then Formulaes

Look for examples of Nested Ifs. Check these free examples

zstein · Dec 15th 2005

Re: If/then Formulaes

Thank you both, I will study this information and I'm sure be able to complete the report.

Zane

If/then Formulaes

Participate now!

Share