Rolling highest amount nested IF
Closed
frustrated
-
27 Oct 2009 à 16:29
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 28 Oct 2009 à 20:52
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 28 Oct 2009 à 20:52
Related:
- Rolling highest amount nested IF
- How many nested if statements in excel - Guide
- If a computer with windows xp will not boot up property after upgrading a video driver you should first (...). choose the correct answer.: use the last known good configuration feature roll back the driver after starting in safe mode use the recovery console feature upgrade the operating system ✓ - Windows XP Forum
- Not starting - Software Forum
- Anyone answer me ✓ - Facebook Forum
- I need answer - Instagram Forum
2 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
27 Oct 2009 à 22:17
27 Oct 2009 à 22:17
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 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
28 Oct 2009 à 20:52
28 Oct 2009 à 20:52
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.
28 Oct 2009 à 10:30