annae

Junior Member

Posts: 1

IF function problem,

I'm trying to calculate a maximum amount of value. That is, if a value is higher than 50000, it needs to display 50000. If not, display current value.

A1=35678
B1 should display 35678 (that is, equal to A1)

A1=67980
B1 should display 50000

Last edited by annae : September 13th 19 at 02:33 PM

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 function problem	Sue	New Users to Excel	9	June 19th 09 02:46 PM
Problem with = in function	Raj[_2_]	Excel Worksheet Functions	4	April 20th 09 11:07 AM
Problem with Function	sgreene	Excel Worksheet Functions	12	April 17th 08 11:19 PM
Mid Function Problem	DEI	Excel Discussion (Misc queries)	3	August 9th 06 08:08 PM
PC to MAC VBA function problem	cuboid	Excel Programming	2	January 28th 05 05:09 PM

All times are GMT +1. The time now is 01:16 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us