Posted to microsoft.public.excel.setup

Alan

Posts: n/a

check percentage or whole number

Is there a way to check if a user enter a percentage or a regular number into
a cell, then apply different formula to it?

Note: user will enter a huge number like 2,345,678, or 22% (of something)

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
Master invoice number	Christopher M.	Excel Worksheet Functions	0	July 24th 05 04:26 PM
Need to Count number of occurrences and get percentage of total	JennLee	Excel Worksheet Functions	3	June 21st 05 09:56 PM
Random Number Questions	Greegan	Excel Worksheet Functions	1	January 5th 05 02:00 AM
Defining a number in a cell by text then subtracting it by the tex	Crowraine	Excel Worksheet Functions	1	December 16th 04 07:49 AM
a number as a percentage out of a total	solskinn	Excel Worksheet Functions	3	December 8th 04 06:23 PM

All times are GMT +1. The time now is 08:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us