#1
|
|||
|
|||
IF Statement
I have got so close to solving this IF statement, but cannot seem to get it right.
I basically want the formula to do the below (the formula will be in J14). If G14 = Yes and D14 = 2. If this is true then J14 will show the number inside E14, if false it will show J14 will show 0 I need this to work, as this will be the main part to a formula i will create Hopefully it makes sense what i want |
#2
|
||||
|
||||
Perhaps
Code:
=IF(and(G14="Yes",D14=2),E14,0)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
If statement, may be? | Tony Singh | Excel | 6 | 03-04-2015 12:52 PM |
Need help with If, Then Statement Please | cangelis | Excel | 4 | 01-03-2014 09:10 AM |
Help with IF Statement | limpbizkit | Excel | 4 | 02-24-2011 09:16 PM |
if statement | piper7971 | PowerPoint | 1 | 08-19-2010 07:10 AM |
Help with IF statement! | CPelkey | Word | 1 | 04-12-2010 09:06 AM |