LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Mo2 Mo2 is offline
external usenet poster
 
Posts: 34
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
a simple question Zee Excel Discussion (Misc queries) 1 September 18th 06 10:44 AM
Simple question..I think Levi Excel Discussion (Misc queries) 1 May 4th 06 08:34 PM
Very Simple Question John Charts and Charting in Excel 2 January 23rd 06 07:30 PM
Simple Simple Excel usage question BookerW Excel Discussion (Misc queries) 1 June 23rd 05 10:06 PM
Simple VBA question Mark1 Excel Discussion (Misc queries) 1 November 30th 04 10:25 PM


All times are GMT +1. The time now is 04:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"