Forum Discussion
Solved
Assistance with nested formula
Can someone assist? I have created a formula which is working to a point. I just can't figure out how to stop it providing information if the cell has no data in it. What I need is the No of hours...
=IF(ISBLANK(N4),"0",IF(N4<=$S$4,"1",IF(N4<$S$5,"2",IF(N4<$S$6,"3",IF(N4<$S$7,"4","0")))))
=IF(ISBLANK(N4),"0",IF(N4<=$S$4,"1",IF(N4<$S$5,"2",IF(N4<$S$6,"3",IF(N4<$S$7,"4","0")))))
Thanks so much Bob. That worked perfectly.
You're welcome. Glad I could help.
