Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-13-2016, 06:36 AM
jkdiesel jkdiesel is offline IIf Formula Windows 7 64bit IIf Formula Office 2013
Novice
IIf Formula
 
Join Date: May 2016
Posts: 11
jkdiesel is on a distinguished road
Default IIf Formula


How do I use the IIf formula in conjunction with my custom formula [Duration2]/[Minutes Per Day]*[Number1]*800? Id like to use it so that if there is NA or no value in the Duration2 or Number1 column, the chart rolls up to the top instead of giving me an error.

Anyone know how to do such a thing?

Thanks.
Reply With Quote
  #2  
Old 05-15-2016, 06:52 AM
JulieS JulieS is offline IIf Formula Windows 7 64bit IIf Formula Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

I don't know what you mean by 'the chart rolls up to the top'. What value do you want to appear if there isn't anything in Number1 or Duration2? 0?
Reply With Quote
  #3  
Old 05-16-2016, 05:24 AM
jkdiesel jkdiesel is offline IIf Formula Windows 7 64bit IIf Formula Office 2013
Novice
IIf Formula
 
Join Date: May 2016
Posts: 11
jkdiesel is on a distinguished road
Default

yes, 0. if it shows #error, the task wont rollup to the summary tasks, and to the next summary task, etc.
Reply With Quote
  #4  
Old 05-17-2016, 01:01 AM
miless2111s miless2111s is offline IIf Formula Windows 7 32bit IIf Formula Office 2007
Advanced Beginner
 
Join Date: May 2016
Posts: 32
miless2111s is on a distinguished road
Default

Quote:
Originally Posted by jkdiesel View Post
How do I use the IIf formula in conjunction with my custom formula [Duration2]/[Minutes Per Day]*[Number1]*800? Id like to use it so that if there is NA or no value in the Duration2 or Number1 column, the chart rolls up to the top instead of giving me an error.

Anyone know how to do such a thing?

Thanks.
If your task has been entered automatically you will not have NA in either Duration or Number fields. Number will be 0 if nothing has been entered and duration will be 0 Days.
As such you can put in an error catch for this:
iif([duration2]=0 OR [number1]=0),0, ENTER your formula)

If you have entered a task as manual you might have a blank or unusual entry but you can trap this as well with Task Type = Manual

HTH

Miles
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with dragging a formula and changing a reference column as I drag the formula. LupeB Excel 1 10-22-2015 03:02 PM
help with a formula srockwell25 Excel 4 08-22-2014 02:47 AM
Formula muhu Excel 1 04-14-2014 08:19 AM
Formula Help clo312 Excel 11 01-11-2014 02:54 AM
IIf Formula help with formula? doczilla Excel 2 09-25-2011 04:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:04 AM.


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