Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
populating a cell with the difference from another
I have a simple question that I just can't figure it out. I type out what
sounds like it should work, but then excel isn't happy with MY formula. This is how it seems logical to me: =b8(IF40)-40 So, obviously, what I would like to know how to do is populate the excess of 40 into a given cell. Sounds like a simple function but heck if I can figure it out. Thanks for whatever tips you can give me. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
populating a cell with the difference from another
An IF works by evaluating a logic situation, then returning one answer
if the logic is evaluated as True and another if the evaluation is False. The format is IF(logical question, true evaluation, false evaluation). So if I read your post right, your formula should look like this: =IF(B840,B8-40,0) This returns a zero if B8 is less than 40. You can enter another response such as "" (2 double quotes) if you want to return a blank cell. Does that do it for you? Dave O |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
populating a cell with the difference from another
=IF(B840,B8-40,B8)
"ng66" wrote: I have a simple question that I just can't figure it out. I type out what sounds like it should work, but then excel isn't happy with MY formula. This is how it seems logical to me: =b8(IF40)-40 So, obviously, what I would like to know how to do is populate the excess of 40 into a given cell. Sounds like a simple function but heck if I can figure it out. Thanks for whatever tips you can give me. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
populating a cell with the difference from another
It isn't entirely clear what you are trying to do. If you want the amount
by which B8 exceeds 40, and to output 0 if B8 doesn't exceed 40, then try =MAX(B8-40,0) If you want it blank if B8 doesn't exceed 40, then try =IF(B840,B8-40,"") -- David Biddulph "ng66" wrote in message ... I have a simple question that I just can't figure it out. I type out what sounds like it should work, but then excel isn't happy with MY formula. This is how it seems logical to me: =b8(IF40)-40 So, obviously, what I would like to know how to do is populate the excess of 40 into a given cell. Sounds like a simple function but heck if I can figure it out. Thanks for whatever tips you can give me. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
populating a cell with the difference from another
Thanks, Dave. Weird thing is it worked for column B but when I changed the
formula for other columns (I need it for columns B-F), it populated the formula and not the result of it. All I did was change the column letter. Should I convert it in some other way? Thanks again! "Dave O" wrote: An IF works by evaluating a logic situation, then returning one answer if the logic is evaluated as True and another if the evaluation is False. The format is IF(logical question, true evaluation, false evaluation). So if I read your post right, your formula should look like this: =IF(B840,B8-40,0) This returns a zero if B8 is less than 40. You can enter another response such as "" (2 double quotes) if you want to return a blank cell. Does that do it for you? Dave O |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
populating a cell with the difference from another
If you see the formula and not its calculation, the cell in question is
likely formatted as text. Format as General, or Number, or something else. Dave -- Brevity is the soul of wit. "ng66" wrote: Thanks, Dave. Weird thing is it worked for column B but when I changed the formula for other columns (I need it for columns B-F), it populated the formula and not the result of it. All I did was change the column letter. Should I convert it in some other way? Thanks again! "Dave O" wrote: An IF works by evaluating a logic situation, then returning one answer if the logic is evaluated as True and another if the evaluation is False. The format is IF(logical question, true evaluation, false evaluation). So if I read your post right, your formula should look like this: =IF(B840,B8-40,0) This returns a zero if B8 is less than 40. You can enter another response such as "" (2 double quotes) if you want to return a blank cell. Does that do it for you? Dave O |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions |