Posted to microsoft.public.excel.worksheet.functions

JcR

Posts: n/a

equals the actual number...not text ????

I have a formula in e2 that goes like this:
=IF(d250,"50",IF(d225,"25",IF(d2<26,a2)))

d2=b2*c2
a2 would be a number between 1 and 150

then i want to put the greater of a2 and e2 into f2
and writing like this =max(a2,e2)

it won't select the value in e2, it always elects value in a2

how can i fix ?

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
Setting the number of decimal places for a text box.	Aaron1978	Excel Discussion (Misc queries)	3	March 8th 06 04:59 PM
number returns only two decimal places after I change from text	quale	Excel Discussion (Misc queries)	5	December 8th 05 08:22 PM
Change number format from text to number?	Scot	New Users to Excel	2	December 1st 05 04:15 PM
Conversion of a Number into English Text	Nasir Ali	Excel Worksheet Functions	1	July 28th 05 08:50 AM
Format Number to Text	Roni	Excel Worksheet Functions	2	May 17th 05 03:17 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us