Posted to microsoft.public.excel.newusers

Liz

external usenet poster

Posts: 133

How to use the conditions? - Liz

I need help with this if anyone can help me with this:

A1=$1500
B1=$1500

I want to create a logic that if B1 is greater or equal to A1 then YES and
if B1 is less than A1 then NO. And if the cells A1 or B1 is blank then the
result cell should also appear blank and should not show #Value? or other
values in the conditioned cell.

What should I should to get this conditioned in one cell?

Thanks
Liz

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
shade cells based on conditions - i have more than 3 conditions	Mo2	Excel Worksheet Functions	3	March 30th 07 07:19 AM
Sum if 2 conditions are met	kieffer	Excel Worksheet Functions	1	April 14th 06 01:02 AM
Conditions Help	Curtis	Excel Worksheet Functions	2	March 10th 06 08:02 PM
SUM 2 Conditions	mav3n	Excel Worksheet Functions	3	August 15th 05 11:04 PM
How to multiple conditions to validate more than 2 conditions to .	Bhuvana Govind	Excel Worksheet Functions	1	January 28th 05 07:07 PM

All times are GMT +1. The time now is 11:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us