excel if statements multiple conditions

January 18, 2011 at 08:47:25
Specs: Windows XP
I have 2 sheets - one sheet has customer names, the other sheet has customer names, date closed, dollar amounts and then a column stated closed. I want to be able to have when I mark closed on the client name for that dollar amount to be filled in on the first sheet. I have tried the following if statement, but it is not working

=IF(A4=Forecast!$B$1:$B$15, TRUE, Forecast!$G$1:$G$14)

See More: excel if statements multiple conditions

Report •

January 18, 2011 at 09:31:32
Keep in mind that we can't see your spreadsheets from where we're sitting, so we have no reference point from which to evaluate your formula.

That said, that doesn't look like a typical IF statement that checks a cell for a value/string and returns a value based on what it finds.

Please read the How To in the following line and then post some examples of your data and the expected results based on those examples.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

January 18, 2011 at 09:33:16
=IF(A4=Forecast!$B$1:$B$15, TRUE, Forecast!$G$1:$G$14)

In this instance, you are referencing the same sheet.

Sheet1! Sheet2! and so on.

Try a google for if statements. This will help you in setting upa conditional statement.

I'm learning.

Report •

January 18, 2011 at 10:27:38

Sheet 1
Name Payroll Amount

Sheet 2
Name Closed Date Amount Funded
Smith 1/14/11 $150 Yes
Martin 1/25/11 $500 No
Mitchell 1/7/11 $200 Yes

Here is a view of what I am faced with in my excel sheets they are very lenghty and multi people use them. So what I wanted to set it up to have the person that is working on the detail to mark yes or in the funded column. This would then pull the dollar amount to the first sheet. So what I am trying to do is have technically a main sheet for payroll with the person's name and the amount that he gets paid. In order to avoid errors, I just want the people who are stating the these are complete by putting yes or no. I have been trying to do different ways to make it easy, but nothing has been working for me.

Report •

Related Solutions

January 18, 2011 at 14:27:17
I see that you did not read the How To as I requested.

Well, maybe you read it, but you sure didn't follow the instructions given.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

January 19, 2011 at 06:07:00
I normally would be saying thanks as you helped me, but I did figure it out myself. So thanks, but no thanks.....

Report •

Ask Question