| 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 |
|
#2
|
|||
|
|||
|
Annette,
=IF(COUNTIF(M5:Q5,0)=0,"What to do if true", "What to do if false") perhaps: =IF(COUNTIF(M5:Q5,0)=0,L5*K5,0) HTH, Bernie MS Excel MVP "Annette" wrote in message ... 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 |
| Reply |
| 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) | |||
Linear Mode
