“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Counting present value from future value

Solved by I. Y. in 29 mins

did i calculate the present value properly?

Solved by Z. U. in 17 mins

Hi - I have a sheet with two columns of student results. Some columns contain empty cells (where the pupil was not present in school) and some contain values (where the pupil was present. Is there a way excel can copy the value in the first column, but if that cell is empty, copy the value in the second cell?

Solved by T. E. in 25 mins

Trying to work out a formula with cascading If statements. In cells B10:B13, copy vlaues from A1:E5 with the logic IF VALUE PRESENT IN Option 1, copy value in option 1, otherwise look in Option 2, otherwise Option 3 and Option 4. If no value present in any of the options, copy 0.

Solved by F. C. in 23 mins

if value present in A it should indicate diff colour while I entering value in B

Solved by C. W. in 21 mins