#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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?
|
#3
|
|||
|
|||
yes, 0. if it shows #error, the task wont rollup to the summary tasks, and to the next summary task, etc.
|
#4
|
|||
|
|||
Quote:
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 |
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 |
help with formula? | doczilla | Excel | 2 | 09-25-2011 04:14 PM |