Posted to microsoft.public.excel.worksheet.functions

Michael in Georgia Michael in Georgia is offline

external usenet poster

Posts: 1

How do I use functions and calculations?

I'm having trouble with this conditional, nesting, logic and calculating
scenario.

If x is less than 500, then "$500." If x is between 500.01 and 650, then
"$650. If x is greater than 650, then "$650."

--Michael Manning

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
Confused about arrays and ranges in functions	Llurker	Excel Worksheet Functions	0	July 7th 05 05:44 AM
How wrong can you be with your NPV and MIRR functions in EXCel	opieandy	Excel Worksheet Functions	3	June 27th 05 10:15 PM
remote functions	rob1234	Excel Worksheet Functions	1	May 12th 05 06:18 PM
Data calculations require more than 7 nested functions	F6Hawk	Excel Worksheet Functions	4	November 9th 04 06:47 AM
Data calculations require more than 7 nested functions	F6Hawk	Excel Worksheet Functions	0	November 8th 04 04:18 PM

All times are GMT +1. The time now is 02:28 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us