Posted to microsoft.public.excel.worksheet.functions

Jon

Posts: n/a

Conditional Formula

I am wanting to write a formula where J8 J7 and return the result "Yes" in
K8. If J7 is blank the the formula needs to look at J8J6.
I wrote this:
=IF(AND(J81,J8J7),"Yes","") Does not get he result I am looking for.
From here I need help!

Thanks

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
need a conditional formula to generate numbers divisible by 4 between a given starting no. & end No.	ramana	Excel Worksheet Functions	5	October 21st 05 07:39 AM
Conditional formatting...cont. from 9/25	Guenzak	Excel Discussion (Misc queries)	4	September 26th 05 10:55 PM
conditional formula	Kari	Excel Worksheet Functions	1	September 22nd 05 04:50 PM
Conditional Formatting formula not acceptable?	Thief_	Excel Discussion (Misc queries)	4	July 19th 05 11:54 AM
Formula Dependant Conditional Formatting	LDanix	Excel Discussion (Misc queries)	1	January 13th 05 06:50 PM

All times are GMT +1. The time now is 03:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us