Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting the number of decimal places for a text box. | Excel Discussion (Misc queries) | |||
number returns only two decimal places after I change from text | Excel Discussion (Misc queries) | |||
Change number format from text to number? | New Users to Excel | |||
Conversion of a Number into English Text | Excel Worksheet Functions | |||
Format Number to Text | Excel Worksheet Functions |