Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF statement help
I am working on an If statement that shows a "yes" or "no" depending if it is <= or = to one percent. This is what I have and it works fine. =IF('Funding'!$G3<=1%,"yes",IF('Funding'!$G3=1%," no!")) The problem is that column G is just the range of numbers, and it must reference another column that has a list. For example, "45-019" would be in the current worksheet as one instance(d3) but this number can be repeated again say in cell D8. Another worksheet has all of the list of numbers in column A that will be used. Is it even possible to include the list from the other worksheet for each instance on the worksheet with the formulas and still keep the above statement? If so, can someone please help? -- NeedHelp321 ------------------------------------------------------------------------ NeedHelp321's Profile: http://www.excelforum.com/member.php...o&userid=24691 View this thread: http://www.excelforum.com/showthread...hreadid=382618 |
#2
|
|||
|
|||
Your formula doesn't really work fine, as you are saying that if G3=1% return both 'yes' and 'no'. You also nested IF statements that really aren't necessary. Try this instead: =IF('Funding'!$G3<=1%,"yes","no!") which will return "no!" for any value greater than 1% As for the rest of your question, I don't understand what it is you are looking for. If you could be more specific with details, please, someone may be able to give some ideas for solutions. Good Luck Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=382618 |
#3
|
|||
|
|||
Thank you, that did shorten the IF statement. I think I may need a Lookup function because if I type in =LOOKUP(D3,List) in another cell, it will return the value I need. "List is the range of cells that include all of the numbers in the 'funding' worksheet. This is what I have, but it does not work: =IF('Funding'!$G1<=1%,"yes!","no")(LOOKUP(D3,WBSLi st)) It's basically the 'funding' worksheet has one instance of a number(column A) and on that worksheet is the percent (column G) that can be negative or positive. The other worksheet has that same number from Column A from the 'funding' worksheet put in Column D of the 'Log' Worksheet. In column I of the 'Log' Worksheet is where the "yes" or "no" value goes. I hope this makes sense. I've tried seeing this as a puzzle, but to me its a puzzle with a missing piece. -- NeedHelp321 ------------------------------------------------------------------------ NeedHelp321's Profile: http://www.excelforum.com/member.php...o&userid=24691 View this thread: http://www.excelforum.com/showthread...hreadid=382618 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
What statement to use? | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
7+ nested if statement? | Excel Worksheet Functions | |||
Statement | Excel Worksheet Functions |