Cell doesn't appear in calculations

[sjohns17]

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?

[Bill Kuunders]

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(G3>25,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" <sjoh...@discussions.microsoft.com> wrote in message
news:CD21FE75-F0D6-4C72...@microsoft.com...

[Eduardo]

Hi,
the formula given have an error change it for

IF(g3<=25,25,IF(g3>25,g3))

your formula included if G3<= and as 2nd if F3<, both if were looking the
same, I think you wanted to do G3>25 in the 2nd if

if this helps please click yes thanks

[Bill Kuunders]

And the formula could of course be simpler
=IF(G3>=25,25,G3)
Regards

"Bill Kuunders" <bill.k...@xtra.co.nz> wrote in message
news:u%23htbKng...@TK2MSFTNGP06.phx.gbl...

[Niek Otten]

Eeven shorter:

=IF(G3>25,25,G3)

Again shorter:

=MIN(G3,25)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Bill Kuunders" <bill.k...@xtra.co.nz> wrote in message

news:eQe5Wjng...@TK2MSFTNGP06.phx.gbl...