Posted to microsoft.public.excel.worksheet.functions

sgreene

external usenet poster

Posts: 11

Problem with Function

=If(N6=4.6,€Assertive",IF(N6<=4,"Not
Assertive",if(AND(N64.1,N6<=4.5,"Somewhat Assertive"))))

In this example what I want it to do is if
1. the number that appears is greater than 4.6 it should put in Assertive
2. the number that appears is equal to or less than 4.0 should put in Not
Assertive
3. the number that appears is greater than or equal to 4.1 and less than or
equal to 4.5 should put in Somewhat assertive
Please tell me what I am doing wrong!!
Thank you.

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
Problem with IRR function	Keith	Excel Worksheet Functions	2	May 21st 07 01:40 PM
Function problem	Winnie	Excel Discussion (Misc queries)	2	October 9th 06 01:31 PM
Problem with IF function	haitch2	Excel Worksheet Functions	3	October 10th 05 01:05 AM
FV Function Problem	TerryG	Excel Worksheet Functions	3	June 13th 05 09:26 PM
IF function problem	dvonj	Excel Worksheet Functions	13	March 10th 05 01:13 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us