Can someone explain to me why this formula does not work and perhaps how to correct it?
=IF(M4>N4,M4,N4)
It will not show the number in M4 if there is no number in N4 (it just shows a 0), once a number greater than 0 is produced in N4 then the formula works.
What happens with:
=MAX(M4,N4)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
works fine for me. You might want to check the format for the 2 cells to make sure they are not formatted as Text
Thanks, that worked.just a few more questions to go now. LOL
You could also try the following to catch the gaps from column N:
=IF(N7=0,M7,IF(M7>N7,M7,N7))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks