Keith

Posts: n/a

Trouble with formula

I am trying use the following formula in cell M6. =IF(K6<25,25,K6-L6) but it
returns "value!" if K6 is blank. But if K6 is blank I want it to leave the
cell blank. I have tried everything I can think of. Could you help me with
this.

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
Trouble with formula	Kristajea	Excel Worksheet Functions	4	May 20th 05 12:28 AM
Trouble with Syntax - IF formula	Bert via OfficeKB.com	New Users to Excel	1	April 8th 05 01:00 AM
Howdo U copy a formula down a column, that uses data in another w.	Need Help pasting a formula	Excel Worksheet Functions	1	February 25th 05 06:04 PM
Problem with VBA returning the contents of a long formula.	[email protected]	Excel Discussion (Misc queries)	2	February 23rd 05 12:14 AM
Formula or not?	Alan	Excel Worksheet Functions	2	February 20th 05 03:26 PM

All times are GMT +1. The time now is 05:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us