Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell doesn't appear in calculations
I used an IF function to generate the cells in one column. E.g.,
IF(g3<=25,"25,IF(g3<25,g3)). Now I want to use the results of that column in summing something else and the sum function basically doesn't 'see' the cell at all. The results are as if there were no numbers there at all. What gives? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell doesn't appear in calculations
I assume you want this in the formula
=IF(G3=25,25,IF(G3<25,G3)) anything larger than 25 is 25 or it could be =IF(G3<=25,25,IF(G325,G3)) anything smaller than 25 is 25 in any case do not use "25" it is treated as text in the summing excercise Greetings from New Zealand "sjohns17" wrote in message ... I used an IF function to generate the cells in one column. E.g., IF(g3<=25,"25,IF(g3<25,g3)). Now I want to use the results of that column in summing something else and the sum function basically doesn't 'see' the cell at all. The results are as if there were no numbers there at all. What gives? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell doesn't appear in calculations
Hi,
the formula given have an error change it for IF(g3<=25,25,IF(g325,g3)) your formula included if G3<= and as 2nd if F3<, both if were looking the same, I think you wanted to do G325 in the 2nd if if this helps please click yes thanks "sjohns17" wrote: I used an IF function to generate the cells in one column. E.g., IF(g3<=25,"25,IF(g3<25,g3)). Now I want to use the results of that column in summing something else and the sum function basically doesn't 'see' the cell at all. The results are as if there were no numbers there at all. What gives? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell doesn't appear in calculations
And the formula could of course be simpler
=IF(G3=25,25,G3) Regards "Bill Kuunders" wrote in message ... I assume you want this in the formula =IF(G3=25,25,IF(G3<25,G3)) anything larger than 25 is 25 or it could be =IF(G3<=25,25,IF(G325,G3)) anything smaller than 25 is 25 in any case do not use "25" it is treated as text in the summing excercise Greetings from New Zealand "sjohns17" wrote in message ... I used an IF function to generate the cells in one column. E.g., IF(g3<=25,"25,IF(g3<25,g3)). Now I want to use the results of that column in summing something else and the sum function basically doesn't 'see' the cell at all. The results are as if there were no numbers there at all. What gives? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell doesn't appear in calculations
Eeven shorter:
=IF(G325,25,G3) Again shorter: =MIN(G3,25) -- Kind regards, Niek Otten Microsoft MVP - Excel "Bill Kuunders" wrote in message ... And the formula could of course be simpler =IF(G3=25,25,G3) Regards "Bill Kuunders" wrote in message ... I assume you want this in the formula =IF(G3=25,25,IF(G3<25,G3)) anything larger than 25 is 25 or it could be =IF(G3<=25,25,IF(G325,G3)) anything smaller than 25 is 25 in any case do not use "25" it is treated as text in the summing excercise Greetings from New Zealand "sjohns17" wrote in message ... I used an IF function to generate the cells in one column. E.g., IF(g3<=25,"25,IF(g3<25,g3)). Now I want to use the results of that column in summing something else and the sum function basically doesn't 'see' the cell at all. The results are as if there were no numbers there at all. What gives? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculations within a cell | New Users to Excel | |||
Cell Calculations | Excel Worksheet Functions | |||
how to do 2 calculations in 1 cell | Excel Discussion (Misc queries) | |||
Calculations based on cell value | Excel Worksheet Functions | |||
Cell Calculations | Excel Worksheet Functions |