Sam Summers
Registered User.
- Local time
- Today, 10:35
- Joined
- Sep 17, 2001
- Messages
- 939
Hi guys,
searched and attempted but not getting this one at all
I need a formula based from one cell AE30 answer to be displayed in AF30:
If AE30 value >2 then AF30 = 0.2
If AE30 value is between 1 and 2 then AF30 =0.1
Else AF30 = 0
Any ideas?
Many thanks in advance
searched and attempted but not getting this one at all

I need a formula based from one cell AE30 answer to be displayed in AF30:
If AE30 value >2 then AF30 = 0.2
If AE30 value is between 1 and 2 then AF30 =0.1
Else AF30 = 0
Any ideas?
Many thanks in advance