Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-17-2016, 09:30 AM
paxon paxon is offline nested formula using IF & AND Windows XP nested formula using IF & AND Office 2007
Novice
nested formula using IF & AND
 
Join Date: Feb 2016
Posts: 13
paxon is on a distinguished road
Default nested formula using IF & AND

I would like to know if it is possible to make a nested formula with IF & AND with the following logic:
If the difference between two dates is negative (column “I”) give me 0; otherwise if the difference is positive (column “j”) and the range of cell is = to OPEX then do the calculation (OPEX/365*nr.of days)
You can see the attached file as example. (the yellow cells are the one that formula is not correct, I want 0 value because number of days is negative.



Thanks
Attached Files
File Type: xlsx Book1.xlsx (9.8 KB, 17 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
nested formula using IF & AND Nested IF TDWolsey Excel 2 01-06-2016 11:31 PM
nested if and averageA windseaker Excel 0 08-14-2015 04:13 PM
nested formula using IF & AND using if and nested vlookup wentworth16238 Excel 5 06-14-2015 12:59 PM
Nested Vlookup Help asluder2000 Excel 2 11-14-2014 11:00 PM
nested formula using IF & AND Nested IFs JimS378 Excel 7 05-03-2011 08:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:55 PM.


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