Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 06:57 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