| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If then statement to calculate data
Trying to look thru Column starting at line 74,63,52,41 and finally
going to 30 to see where data appears first. Even if there is data in 30 and 41, I want to look where the data appears first from bottom of sheet ..say line 63. Have following fomula but not working: =IF('Piazzo Ware'!C74<0,C74,IF('Piazzo Ware'!C63<0,C63,IF('Piazzo Ware'!C52<0,C52,IF('Piazzo Ware'!C41<0,C41,IF('Piazzo Ware'! C30<0,C30,0))))) Please help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Does an if statement calculate both the true and false? | Excel Discussion (Misc queries) | |||
| need help with if statement that calculate minimum figure | Excel Worksheet Functions | |||
| My IF statement is stating False but if I manual calculate it it | Excel Discussion (Misc queries) | |||
| how can i calculate a three variable if statement in excel | Excel Worksheet Functions | |||
| How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions | |||
![Ric[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
