| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
simple Question
hi
this is my formula: =IF(D25=0,0,IF(D26=0,0,A26)) problem: active cell should equal 0, if D25's value is not between 0 and 7 (the same for the D26 reference) how would i do this? tia |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
simple Question
One way:
=IF(AND(D250,D25<7),IF(AND(D250,D26<0),A26,0),0) another: =IF(COUNTIF(D25:D26,"0")+COUNTIF(D25:D26,"<7")=4, A26,0) another: =IF(OR(D25<0,D26<0,D257,D267),0,A26) In article , Mo2 wrote: hi this is my formula: =IF(D25=0,0,IF(D26=0,0,A26)) problem: active cell should equal 0, if D25's value is not between 0 and 7 (the same for the D26 reference) how would i do this? tia |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| a simple question | Excel Discussion (Misc queries) | |||
| Simple question..I think | Excel Discussion (Misc queries) | |||
| Very Simple Question | Charts and Charting in Excel | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| Simple VBA question | Excel Discussion (Misc queries) | |||
Hybrid Mode
