Thread: IIf Formula
View Single Post
 
Old 05-13-2016, 06:36 AM
jkdiesel jkdiesel is offline Windows 7 64bit Office 2013
Novice
 
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