k what I'm trying to do is make/find a function/series of functions so that if a cell contains a decimal, it should be shown as 0. to give you something to work with:

Cell A1 has a value of 7.26, A2 has a value of 8.75, A3 has a value of 10, and A4 has a value of 4. I want to have a function that will check to see if cell A1 has a decimal or is equal to 0, and if it does, check cell A2, and keep checking until it finds a cell with a whole number. If every cell has a decimal, or is equal to 0, then display 0. If a cell does have a whole number, then let it show that value. I need it to check in order from A1 to A4, so that if cell A3 and A4 have a whole number value, then it should display cell A3 and not A3.

P.S. i know that if it is already equal to 0, then it will display 0, but i need it to check in case another cell after it has a whole number.