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?
|