Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have two Sheets (sheet1,sheet2), Sheet 1 has corridinate data imported from
Autocad. On Sheet 2, cells B57 through B76 have IF statements in them for calculating data from Sheet 1. What I want to do is check if cell B76 equals 0. If the cell equals 0 then go to cell b75 and check if it equals 0 and so on. When it gets to the first cell that is greater than 0 do a calculation that would return a value to cell B77, and stop checking. Is this possible without using VBA programming ? Thanks for your input |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copying cell names | Excel Discussion (Misc queries) | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |