Posted to microsoft.public.excel.misc

JohnD

Posts: n/a

how to use the IF formula with a range of cells

I have a text in one cell (J2) and have to compare it with text in a range of
cells (B2:B999) to return an expression if true. I have tried using the IF
function e.g
IF(J2=B2:B28,"Ordered","Not Ordered"), but it doesn't appear to like working
with a range of cell, works fine if you I point it to a single cell. Any help
would be appreciated.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Formula for % of "yes" in range of cells?	npw	Excel Worksheet Functions	1	April 25th 06 12:38 AM
dynamically select a range of cells for use in a formula	isofuncurves	Excel Worksheet Functions	1	February 2nd 06 01:34 AM
Match then lookup	Tenacity	Excel Worksheet Functions	9	December 3rd 05 05:30 AM
Formula Problem - interrupted by #VALUE! in other cells!?	Ted	Excel Worksheet Functions	17	November 25th 05 05:18 PM
Formula help for using a range of cells!	Sukismomma	Excel Worksheet Functions	5	January 27th 05 02:34 AM

All times are GMT +1. The time now is 10:00 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us