| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF formula over multiple sheets
Good morning
Im trying to create a formula in sheet 1 that looks at values in sheets 2, 3 and 4 and searches for a 0. If it finds a 0 I want it to return a value of 'Fail', if it doesnt I want it to return a value of 'Pass'. As it stands I just keep getting 'VALUE' returned and I think the problem Im having maybe related to that fact that Im trying to make this work over various sheets. Any ideas? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data exctraction from multiple sheets | Excel Discussion (Misc queries) | |||
| Copy formula into multiple cells without changing range | Excel Worksheet Functions | |||
| formula to add up on multiple sheets | Excel Worksheet Functions | |||
| Recurring Excel Formula error - multiple users affected! | Excel Discussion (Misc queries) | |||
| insert Rows with Formulas in Place on Multiple Sheets? | Excel Discussion (Misc queries) | |||
Threaded Mode
