Hello Everyone, I am trying to create a nested IF function in cell Y2 which will see if there is a positive value in cell AQ2 and return the contents of that cell if there is a value. If not then I would like to see if there is a value in cell AR2 and if there is then return the value of that cell. If neither of these are true then I would like to return the value of cell X2. Here is the formula I have been using =IF(AQ2>0,AQ2,IF(AR2>0,AR2,X2)). Unfortunately this will only read and return values in AQ and comes up blank when there is no value in AQ2. Another problem I think I'll have is that I will need the numbers to be rounded as they appear in the original cell (values in cell AQ have to be rounded to the hundredth and values in AR have to be rounded to the nearest whole number. Thanks in advance for your help.