Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 04-06-2015, 01:15 AM
skywriter skywriter is offline IF formula using dates Windows 7 32bit IF formula using dates Office 2010 32bit
Novice
 
Join Date: Apr 2015
Posts: 5
skywriter is on a distinguished road
Default

If your formula is exactly as you wrote it.
=IF(B14>C1,"=G14",0)+IF(B14=C1,"=G14",0)
then your problem is "=G14", you don't use quotes and you don't use the = sign.

It should be written as so.
=IF(B14>C1,G14,0)+IF(B14=C1,G14,0)

To explain this formula just to confirm that it's set to do what you want.

If B14 is greater than C1, you get the value in G14, otherwise you get 0.
The second part, if B14 = C1, it will return the value in G14, otherwise 0.

You are adding these two together, but since it can't be greater than and equal to at the same time I think your formula would be better to look like this.

=IF(B14>=C1,G14,0)
This say if it's greater than OR equal to give me the value in G14, otherwise return 0.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
IF formula using dates IF Formula to calculate dates Sophie1 Excel 2 04-23-2014 07:19 AM
IF formula using dates Changing Actual Finish dates changes original Finish dates SomewhereinTX Project 3 12-20-2013 10:25 AM
IF formula using dates Automating dates OCM Outlook 4 04-03-2013 08:29 PM
If formula for subtracting dates gbaker Excel 6 10-07-2012 07:06 AM
IF formula using dates Calculating dates Daria11 Word VBA 1 06-08-2011 06:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:54 AM.


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