westwiz777
New Member
- Joined
- Jun 15, 2020
- Messages
- 2
- Office Version
- 365
Hi....I'm new to this forum and would appreciate help in writing a formula ....I've Googled plenty seeking answers and am obviously still doing something wrong...I think it's an =IF (AND...???
1. If cell entry is less than 3.5 in say column B:B then divide figure in cell A1 by 100......I have no issues with that
2. If cell entry is between 3.5 and 7.4 in column B:B then divide figure in cell A1 by 0.6
3. If cell entry is between 7.4 and 11 in column B:B then divide figure in cell A1 by 0.4
as each entry is populated in column B:B.....then adjacent cell in say column C:C will show formula outcome as per above. ( I keep getting too many arguments and other errors)
Many thanks in advance
Cheers Ken
1. If cell entry is less than 3.5 in say column B:B then divide figure in cell A1 by 100......I have no issues with that
2. If cell entry is between 3.5 and 7.4 in column B:B then divide figure in cell A1 by 0.6
3. If cell entry is between 7.4 and 11 in column B:B then divide figure in cell A1 by 0.4
as each entry is populated in column B:B.....then adjacent cell in say column C:C will show formula outcome as per above. ( I keep getting too many arguments and other errors)
Many thanks in advance
Cheers Ken