Pete
12-02-2009, 07:36 AM
Need a if formula to do the following:-
1. if cell E is > 5% or less then 0%
and
2. if cell B is >50000
then in cell e calculate the difference of Cell C - B
1. if cell E is > 5% or less then 0%
and
2. if cell B is >50000
then in cell e calculate the difference of Cell C - B