Posted to microsoft.public.excel.worksheet.functions

Gary Wessle Gary Wessle is offline

external usenet poster

Posts: 1

nested if

Hi

how can I write a function to check if 4 cells contain negative number
then it returns the word "neg" but if all cells are positive it return
"pos"?

thanks alot

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
Help Nested If and And	madeleine	Excel Worksheet Functions	2	June 20th 07 03:10 PM
nested if based on nested if in seperate sheet. how?	scouserabbit	Excel Worksheet Functions	5	March 2nd 07 04:03 PM
Nested Ifs	Amy	Excel Worksheet Functions	3	October 9th 06 01:54 AM
Nested Ifs	Sal	Excel Worksheet Functions	5	April 16th 06 10:43 AM
Nested If with And	TheLeafs	Excel Worksheet Functions	2	August 24th 05 05:24 PM

All times are GMT +1. The time now is 07:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us