PDA

View Full Version : Solved: if formula



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

Bob Phillips
12-02-2009, 07:42 AM
You can't have a formula in E that uses the value in C, that is a circular reference.

I will presume that you mean C

=IF(AND(B2>5000,OR(C2<0%,C2>5%)),C2-B2,"")

Pete
12-02-2009, 07:43 AM
yes apologies........