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!