Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
populating a cell with the difference from another | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions |