Hello
I'm trying to make sheet that I will be able to put orders, amount of planed hours on task and devide for different type of teams, employees.
I have stuck on one logic function. At the moment, when not all informations are typed in, function below returns blank cell.
=IF(ISERROR(PRORATE($[Total hours]32, $Start32, $Finish32, DATE(2017, [1]$2, [1]$4), DATE(2017, [1]$3, [1]$5))), "", PRORATE($[Total hours]32, $Start32, $Finish32, DATE(2017, [1]$2, [1]$4), DATE(2017, [1]$3, [1]$5)))
I would like to add to it also logic function, that will return blank cell if result of function is equal 0 (zero)
Do You have any idea?
Example of this sheet is available below.
https://app.smartsheet.com/b/publish?EQBCT=0d91ca8bc3bb4ae096bce2b0d4c3b280