Leigh Kuavopalo
New member
- Joined
- Mar 11, 2016
- Messages
- 2
- Reaction score
- 0
- Points
- 0
If Error Statement
- Thread starter Leigh Kuavopalo
- Start date
Ron Coderre
Member
- Joined
- Aug 11, 2015
- Messages
- 110
- Reaction score
- 1
- Points
- 16
- Location
- Boston, MA
- Excel Version(s)
- 2013, 2016, O365
Using your posted scenaro...
Try this formula, copied down:
C1: =B1*IF(AND(A1<=77.09%,A1<>""),0.5,1)
These are the results:
Is that something you can work with?
A | B | |
1 | | 900.00 |
2 | 77.09% | 900.00 |
3 | 50.00% | 900.00 |
Try this formula, copied down:
C1: =B1*IF(AND(A1<=77.09%,A1<>""),0.5,1)
These are the results:
A | B | C | |
1 | | 900.00 | 900 |
2 | 77.09% | 900.00 | 450 |
3 | 50.00% | 900.00 | 450 |
Is that something you can work with?
Leigh Kuavopalo
New member
- Joined
- Mar 11, 2016
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Thank you Ron!!! It worked 
Very much appreciate your quick response.
Very much appreciate your quick response.