try
=IF(ISBLANK(A2),"",IF(A2<0.3,"",A2-A1))
or in a neater format
=IF(OR(ISBLANK(A2),A2<0.3),"",A2-A1)
Hope this helps
Rowan
"Jonibenj" wrote:
I have the following set-up with 3 cells:
A1 - a target percentage value (30.00%)
A2 - the actual value
A3 - the deviation
Each cell is formatted for percentages. I have inserted the following
formula into A3:
=IF(ISBLANK(A2),"",IF(A2<30,"",A2-A1)
The formula is supposed to do either of three things:
1. If there is no value in A2, leave A3 blank.
2. If the actual percentage is 30% or lower, leave A3 blank.
3. If the actual percentage is over 30%, calculate the deviation from
the standard.
However, The fromula is not behaving! No matter what I do, the A3 cell
remains blank! What have I done wrong???
Jonathan.
--
Jonibenj
------------------------------------------------------------------------
Jonibenj's Profile: http://www.excelforum.com/member.php...o&userid=17048
View this thread: http://www.excelforum.com/showthread...hreadid=396355