I am trying to update a spreadsheet that was created by an employee that is no longer with the company. I have been successful in decoding and update all but 1 formula.
ROUND(C6,0)*IF($D$3="Y", 42, 1)
I understand most of that formula except for two parts. I understand that the first part rounds what ever value is in C6 to the 0 decimal place, then it checks D3 to see if the value is "Y", if it is then it takes the rounded number and multiplies it by 42. What I can not figure out is what that final 1
is for. Can anyone enlighten me on what that last 1
is doing?