| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Problem with IF statement
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statement Problem | Excel Worksheet Functions | |||
| Fundamental problem with IF statement | Excel Worksheet Functions | |||
| Fundamental problem with IF statement | Excel Worksheet Functions | |||
| IF statement problem | Excel Worksheet Functions | |||
| IF statement problem | Excel Worksheet Functions | |||
Threaded Mode
