Hello,
I am wondering how I go about using the round formula when I am already using and IF function in a cell for another reason.
Currently I have this formula in place:
=IF($J$3="",SUM(D5:D28),IF($J$3="23 Hour Day",SUM(D5:D27),IF($J$3="24 Hour Day",SUM(D5:D28),IF($J$3="25 Hour Day",SUM(D5:D29))))) - I need to provide hourly information so have it set to add or remove a box depending on time stamp selected. D5:D28/9 will normally be a long figure for example 0.299583333333
What I need to do is return the value in cells D5:D28/29 (Depending on IF function) to 3 decimal places. Cells D5:D28 display 2 decimal place but could make that 3 if it helps.
When I try to add the round function in it just seems to return a true, false or spill comment not an acutal figure.
Hopefully I have made what I am after clear enough, All help much appreciated.
Thanks
I am wondering how I go about using the round formula when I am already using and IF function in a cell for another reason.
Currently I have this formula in place:
=IF($J$3="",SUM(D5:D28),IF($J$3="23 Hour Day",SUM(D5:D27),IF($J$3="24 Hour Day",SUM(D5:D28),IF($J$3="25 Hour Day",SUM(D5:D29))))) - I need to provide hourly information so have it set to add or remove a box depending on time stamp selected. D5:D28/9 will normally be a long figure for example 0.299583333333
What I need to do is return the value in cells D5:D28/29 (Depending on IF function) to 3 decimal places. Cells D5:D28 display 2 decimal place but could make that 3 if it helps.
When I try to add the round function in it just seems to return a true, false or spill comment not an acutal figure.
Hopefully I have made what I am after clear enough, All help much appreciated.
Thanks