Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 303
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,276
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 303
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,440
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculations within a cell papa New Users to Excel 2 June 21st 09 02:17 PM
Cell Calculations Dina Excel Worksheet Functions 3 March 2nd 08 03:32 PM
how to do 2 calculations in 1 cell Joel Excel Discussion (Misc queries) 1 December 13th 07 10:41 AM
Calculations based on cell value Michael Wright Excel Worksheet Functions 2 November 3rd 06 03:15 PM
Cell Calculations Lilbit Excel Worksheet Functions 4 June 23rd 05 05:39 PM


All times are GMT +1. The time now is 10:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"