# Solved formula help in excel

June 22, 2015 at 03:26:50
Specs: Windows 7
 i have 36 columns with an increasing number in each cell left to right... i.e. range is A1 to AJ1 and the numbers start from 7 in A1 and go up to 286 in AJ1. there is no particular factor by which they grow.in the range A2 to AJ2 I want to display a value based on the range in A1:AJ1. Going from left to right the first cell in A1:AJ1 that has a number greater 60, I want the corresponding cell in A2:AJ2 to show the number 1. Once a cell in A2:AJ2 has "1" populated, the formula needs to look for the first value greater than 120 in A1:AJ1 and populate the corresponding cell in A2:AJ2 to show the number 1. And then so on and so forth for every value higher than or equal to the next multiple of 60.any help will be awesomemessage edited by bijalvp

See More: formula help in excel

#1
June 22, 2015 at 07:28:20
 Try putting the formula =INT((A1-1)/60) into A2 and dragging/copying it across the entire row.

Report •

#2
June 22, 2015 at 10:35:19