Posted to microsoft.public.excel.worksheet.functions

Angelsnecropolis Angelsnecropolis is offline

external usenet poster

Posts: 5

Why won't this function work?

This function works:
=IF(B71="","",IF(B71<=330,"Standard","Below Standard"))

But when I change "330" to "R4" it doesn't work. R4 is a number field that
has 330 in it. It doesn't seem to be recognizing the Value_if_False
statement. Any number will make it show "Standard."
=IF(B71="","",IF(B71<=R4,"Standard","Below Standard"))

Your help is 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
Function doesn't work	Neal Carron[_2_]	Excel Worksheet Functions	2	January 26th 10 02:11 AM
need a function that will work using multiple work books and sheet	capt c	Excel Worksheet Functions	1	March 30th 09 10:20 PM
Why does my Function not work?	[email protected]	Excel Discussion (Misc queries)	2	April 27th 07 10:22 PM
NETWORKDAYS Function doesn't work	Dean	Excel Worksheet Functions	4	July 23rd 06 03:50 PM
how do i get the mid function to work with a zero	garbold	Excel Worksheet Functions	7	June 7th 06 10:58 PM

All times are GMT +1. The time now is 04:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us