Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JcR
 
Posts: n/a
Default 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 ?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MarkN
 
Posts: n/a
Default equals the actual number...not text ????

I think that if you look at your IF function and remove the double inverted
commas from the numbers ie. =IF(d250,50,IF(d225,25,IF(d2<26,a2))), then it
should work.
--
Hope this helps,
MarkN


"JcR" wrote:

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 ?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default equals the actual number...not text ????

Hi!

Try removing the quotes from around your numbers:

=IF(d250,50,IF(d225,25,IF(d2<26,a2)))

Biff

"JcR" wrote in message
...
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 ?



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
George
 
Posts: n/a
Default equals the actual number...not text ????

Remove the quotes from the 50 and 25, you are entering them as text not
as number
Also you can lose the last if statement
=IF(d250,50,IF(d225,25,a2)))

George

JcR wrote:
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 ?

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JcR
 
Posts: n/a
Default equals the actual number...not text ????

thanks

"Biff" wrote:

Hi!

Try removing the quotes from around your numbers:

=IF(d250,50,IF(d225,25,IF(d2<26,a2)))

Biff

"JcR" wrote in message
...
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 ?






  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JcR
 
Posts: n/a
Default equals the actual number...not text ????

thanks

"George" wrote:

Remove the quotes from the 50 and 25, you are entering them as text not
as number
Also you can lose the last if statement
=IF(d250,50,IF(d225,25,a2)))

George

JcR wrote:
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 ?


  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JcR
 
Posts: n/a
Default equals the actual number...not text ????

thanks

"MarkN" wrote:

I think that if you look at your IF function and remove the double inverted
commas from the numbers ie. =IF(d250,50,IF(d225,25,IF(d2<26,a2))), then it
should work.
--
Hope this helps,
MarkN


"JcR" wrote:

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 ?

  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default equals the actual number...not text ????

You're welcome!

Biff

"JcR" wrote in message
...
thanks

"Biff" wrote:

Hi!

Try removing the quotes from around your numbers:

=IF(d250,50,IF(d225,25,IF(d2<26,a2)))

Biff

"JcR" wrote in message
...
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 05:59 PM
number returns only two decimal places after I change from text quale Excel Discussion (Misc queries) 5 December 8th 05 09:22 PM
Change number format from text to number? Scot New Users to Excel 2 December 1st 05 05: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 04:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"