Forum Discussion
Need some help to do a planning with different formulas
Hello, I try to do a planning with different formulas, some of which provide different possibilities. * For each day, it would be necessary to calculate the number of hours on the day. * Between t...
This looks a very complex and I am not too sure it is doing what you want
in c2 you have =($B$4-C3)+($C$4+D3) and all the B4 cells are blank.
you could try something like =IF(C3="CH","ERROR",($B$4-C3)+($C$4+D3))
in c2 you have =($B$4-C3)+($C$4+D3) and all the B4 cells are blank.
you could try something like =IF(C3="CH","ERROR",($B$4-C3)+($C$4+D3))
Thanks for your response. It seems appropriate for a single occurrence. In my situation, there are several. I do not know the IF nested functions at all. I think that is what I would need, except if another formula (easy to understand) exists.
Regarding the content of cell C2, the "$ B $ 4" and "$ C $ 4" are cells that contain an hourly value. These cells are used to calculate the number of hours between two services.