Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-10-2015, 02:26 PM
teza2k06 teza2k06 is offline IF Statement Windows 7 64bit IF Statement Office 2010 32bit
Advanced Beginner
IF Statement
 
Join Date: Feb 2013
Posts: 37
teza2k06 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 03-11-2015, 12:44 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline IF Statement Windows 7 64bit IF Statement Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
IF Statement If statement, may be? Tony Singh Excel 6 03-04-2015 12:52 PM
IF Statement Need help with If, Then Statement Please cangelis Excel 4 01-03-2014 09:10 AM
IF Statement Help with IF Statement limpbizkit Excel 4 02-24-2011 09:16 PM
IF Statement if statement piper7971 PowerPoint 1 08-19-2010 07:10 AM
IF Statement Help with IF statement! CPelkey Word 1 04-12-2010 09:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:27 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft