I need to add two cells not in a continuous row or column, say B8 and C7, but
only if the value in C7 is less than zero. If value in C7 is more than zero
need the cell to equal the value in B8
I need to add two cells not in a continuous row or column, say B8 and C7, but
only if the value in C7 is less than zero. If value in C7 is more than zero
need the cell to equal the value in B8
something like this
=IF(C7<0,B8+C7,B8)
=IF(C7<0,B8+C7,B8)
Hope this helps
Rowan
loganinc6 wrote:
> I need to add two cells not in a continuous row or column, say B8 and C7, but
> only if the value in C7 is less than zero. If value in C7 is more than zero
> need the cell to equal the value in B8
Try this:
=B8+MIN(C7,0)
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"loganinc6" <[email protected]> wrote in message
news:[email protected]...
> I need to add two cells not in a continuous row or column, say B8 and C7,
but
> only if the value in C7 is less than zero. If value in C7 is more than
zero
> need the cell to equal the value in B8
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks