If and logic
Closed
antress
Posts
1
Registration date
Wednesday January 2, 2013
Status
Member
Last seen
January 2, 2013
-
Jan 2, 2013 at 10:47 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 4, 2013 at 04:08 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 4, 2013 at 04:08 PM
Hello,
I am trying to write an Excel formula where i have a condition statement that varies result. For example if my target figure is > 30 but less than 50, i want to return a response of 0.1, but if the target is < 30, i want to return a response of 0.05 and if target is greater than 50, i want to return a response of 0.075.
Any help with this is greatly appreciated.
I am trying to write an Excel formula where i have a condition statement that varies result. For example if my target figure is > 30 but less than 50, i want to return a response of 0.1, but if the target is < 30, i want to return a response of 0.05 and if target is greater than 50, i want to return a response of 0.075.
Any help with this is greatly appreciated.
Related:
- If and logic
- Logic pro free download - Download - Musical production
- No usable free extent could be found. it may be that there is insufficient free space to create a partition at the specified size and offset. specify different size and offset values or don't specify either to create the maximum sized partition. it may be that the disk is partitioned using the mbr disk partitioning format and the disk contains either 4 primary partitions, (no more partitions may be created), or 3 primary partitions and one extended partition, (only logical drives may be created). ✓ - Recovery software Forum
- What is the difference between cores and logical processors ✓ - CPU & Desktop Forum
- Comparing two columns using partial match logic ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jan 4, 2013 at 04:08 PM
Jan 4, 2013 at 04:08 PM
=IF(A1="", "", IF(A1<30,0.05,IF(A1<50,0.1,0.075)))
