LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,651
Default IF function not working

On Mon, 5 May 2008 09:16:02 -0700, Loren
wrote:

BF2610<20

Not sure how you derived this syntax.

If what you want is to test for the condition where BF26 is greater than 10 and
also less than 20, the proper syntax is:

AND(BF2610,BF26<20)

If you want something else, you'll need to spell it out in more detail.



--ron
 
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
Old function is not working. Marhes Excel Worksheet Functions 0 June 6th 07 05:23 PM
IF Function not working Loren Excel Discussion (Misc queries) 7 February 26th 07 09:27 PM
Sum function not working, help please! trickdigger Excel Worksheet Functions 2 April 9th 06 03:04 AM
IF(AND function is not working Access Newbie looking for help Excel Worksheet Functions 4 March 20th 06 06:47 PM
IF Function not working sonicj Excel Discussion (Misc queries) 2 February 2nd 05 02:00 AM


All times are GMT +1. The time now is 03:52 PM.

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"