Posted to microsoft.public.excel.misc

external usenet poster

Posts: 191

IF function - with a twist!

Please help if you can.

I am using the IF function and will simplify what I need for explanation
purposes:

I have a value in A1 and a value in B1 and I want to display, in C1, the
larger of the two. The twist is that if that value is not larger than 100, I
want to display 100.

Please help if you can.

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
Sum with a twist	andrew	Excel Discussion (Misc queries)	15	June 18th 08 08:56 AM
Function To Add across Multiple Sheets with a Twist	Sean	Excel Worksheet Functions	11	August 8th 07 10:48 PM
SaveCopyAs with a twist	Rookie 1st class	Excel Discussion (Misc queries)	5	January 21st 07 12:33 AM
Cut / Paste with a Twist	[email protected]	Excel Discussion (Misc queries)	3	July 10th 06 09:51 PM
Large() with twist	Dan	Excel Worksheet Functions	2	January 18th 05 09:53 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us