| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
If with a range
I wanted to include a range in this calculation but not sure how.
=IF(M5="0",L5*K5,0) The range would be if anything found in columns M through Q = 0, then ... How would I write this? Thanks! Annette |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
| Dynamic Print Range Help | Excel Worksheet Functions | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
Threaded Mode
