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.
|