Hi All
I would like to create a formula where
IF F7-D7 is = or < 0 then = 0
IF F7-D7 is = or < G5 then = answer for F7-D7
IF F7-D7 is > G5 then = G5
I've found a bit of stuff on IF conditions in help but nothing that would let you do this
Hi All
I would like to create a formula where
IF F7-D7 is = or < 0 then = 0
IF F7-D7 is = or < G5 then = answer for F7-D7
IF F7-D7 is > G5 then = G5
I've found a bit of stuff on IF conditions in help but nothing that would let you do this
Last edited by Dr M; 01-25-2011 at 12:37 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks