ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   populating a cell with the difference from another (https://www.excelbanter.com/excel-discussion-misc-queries/127744-populating-cell-difference-another.html)

ng66

populating a cell with the difference from another
 
Okay, my last question was answered and it worked perfectly... THANKS JMAY &
DAVE O! (Can you not cut & paste formulas? It made me type out the formula
for each cell I need it for, kind of annoying...)

Anyway, now I tried the following formula for another section (related to
the last one) and although it makes sense to me, Excel doesn't seem to share
my logic: =IF(B840,40)(B8<40,B8)
I think I need an AND/OR or something like that as it doesn't seem like you
can put 2 formulas in one. I even tried it with 2 IFs, but it still didn't
like it.
So, in case it isn't obvious, I would like the cell populated by whichever
answer is true: greater than 40, then 40; less than 40 then the actual number
from that cell.

Thanks again for any help I can get!

Bobt

populating a cell with the difference from another
 
If (B840, 40, B8)

This reads, "If B8 is greater than 40, return 40, else return B8's value".

IF (test, True, False)


Bob Tulk
MOUS

"ng66" wrote:

Okay, my last question was answered and it worked perfectly... THANKS JMAY &
DAVE O! (Can you not cut & paste formulas? It made me type out the formula
for each cell I need it for, kind of annoying...)

Anyway, now I tried the following formula for another section (related to
the last one) and although it makes sense to me, Excel doesn't seem to share
my logic: =IF(B840,40)(B8<40,B8)
I think I need an AND/OR or something like that as it doesn't seem like you
can put 2 formulas in one. I even tried it with 2 IFs, but it still didn't
like it.
So, in case it isn't obvious, I would like the cell populated by whichever
answer is true: greater than 40, then 40; less than 40 then the actual number
from that cell.

Thanks again for any help I can get!


ng66

populating a cell with the difference from another
 
That worked fabulously! And I completely understood it with your english
translation of the formula, THANKS! I so need to take a class! (o: In my
head my formula made perfect sense and just adding the "B8" part on there at
the end didn't, until you put showed me it's "IF (test, True, False)". I get
it now (at least for this example!)

THANKS AGAIN!


"BobT" wrote:

If (B840, 40, B8)

This reads, "If B8 is greater than 40, return 40, else return B8's value".

IF (test, True, False)


Bob Tulk
MOUS

"ng66" wrote:

Okay, my last question was answered and it worked perfectly... THANKS JMAY &
DAVE O! (Can you not cut & paste formulas? It made me type out the formula
for each cell I need it for, kind of annoying...)

Anyway, now I tried the following formula for another section (related to
the last one) and although it makes sense to me, Excel doesn't seem to share
my logic: =IF(B840,40)(B8<40,B8)
I think I need an AND/OR or something like that as it doesn't seem like you
can put 2 formulas in one. I even tried it with 2 IFs, but it still didn't
like it.
So, in case it isn't obvious, I would like the cell populated by whichever
answer is true: greater than 40, then 40; less than 40 then the actual number
from that cell.

Thanks again for any help I can get!



All times are GMT +1. The time now is 10:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com