Rolling highest amount nested IF
Closed
frustrated
-
Oct 27, 2009 at 04:29 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 28, 2009 at 08:52 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 28, 2009 at 08:52 PM
Related:
- Rolling highest amount nested IF
- How many if statements can you nest - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 27, 2009 at 10:17 PM
Oct 27, 2009 at 10:17 PM
suppose thse are in row no. 2
in A2 type this formula
=max(B2:F2)
is this what you want.
what is the nextedif you want.
in A2 type this formula
=max(B2:F2)
is this what you want.
what is the nextedif you want.
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 28, 2009 at 08:52 PM
Oct 28, 2009 at 08:52 PM
what is the version of excel you are having.
if you type in any cell $(space)12 it automatically is entered as $12(no space). It is now a number
but if you type with a single apostrophe (') and type $(space)12 then it will be entered as you have typed but now it is a text or string. you cannot get maximum.
The same thing will happen if the cells are formatted as text and the entry is made as $(space)12.
so the entries in your sheet are strings and not numbers.
now how to solve this or convert these into numbers(or currency numbers) so that max formula can be used
A)if the cells are formatted as text then
1.highlight cells
2.format them as "general"
3. hit F2
4.hit control+shift+enter
all these cells will become numbers and you can do my formula
B) if it is entered with single apostrophe
in my version (windows xp excel 2002) if you highlight this cells on the left there will be an error icon. You click it and choose convert to numbers. Then they would become numbers.
If both these fail you have to have a macro.
experiment this with a small database.
if you type in any cell $(space)12 it automatically is entered as $12(no space). It is now a number
but if you type with a single apostrophe (') and type $(space)12 then it will be entered as you have typed but now it is a text or string. you cannot get maximum.
The same thing will happen if the cells are formatted as text and the entry is made as $(space)12.
so the entries in your sheet are strings and not numbers.
now how to solve this or convert these into numbers(or currency numbers) so that max formula can be used
A)if the cells are formatted as text then
1.highlight cells
2.format them as "general"
3. hit F2
4.hit control+shift+enter
all these cells will become numbers and you can do my formula
B) if it is entered with single apostrophe
in my version (windows xp excel 2002) if you highlight this cells on the left there will be an error icon. You click it and choose convert to numbers. Then they would become numbers.
If both these fail you have to have a macro.
experiment this with a small database.
Oct 28, 2009 at 10:30 AM