Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-10-2016, 10:12 AM
robfreeman robfreeman is offline a complex IF formula perhaps? Windows 7 64bit a complex IF formula perhaps? Office 2010 64bit
Novice
a complex IF formula perhaps?
 
Join Date: May 2016
Posts: 2
robfreeman is on a distinguished road
Default a complex IF formula perhaps?

Hi all

I' trying to put a formula together which will calculate the % +/- of 2 cells dependent on today's date. Has anyone had any luck with this process before?

As you can see, I've already got O39 calculating difference between this current month and may last year and can manually amend the cells to June when the time comes. Is there a nested formula I can use to do this automatically? I got as far as trying multiple IFs but ended up going round in circles!

Any guidance welcome!
Attached Files
File Type: xlsx Patient Population.xlsx (16.8 KB, 10 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
a complex IF formula perhaps? Complex formula question diverdown87 Excel 7 10-21-2014 07:44 AM
Complex Formula using INDEX and Match needed OTPM Excel 5 05-23-2013 01:22 AM
a complex IF formula perhaps? Complex Number Arithmetics Vesnog Excel 4 05-13-2013 05:13 PM
a complex IF formula perhaps? I need help for a complex projet at my job Elok Word 4 01-10-2013 08:28 AM
a complex IF formula perhaps? Complex array formula andrei Excel 9 02-03-2012 03:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:19 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