Forum Discussion
IF Function Question
How do I combine a string of IF AND/OR commands?
Example: =IF(AND(C4<25, 3.25)), IF(AND(C4>25,C4<50, 2.5))
I need to continue the command for 6 more
- This one works:
=IFS(C11<25, 3.25, C11<50, 2.5, C11<75, 2.25, C11<500, 1.9, C11<1000, 1.55, C11<2000, 1.45, C11<3000, 1.35, C11>=3000, 1.25)
6 Replies
Perhaps
=IFS(C4<25, 3.25, C4<50, 2.5, next condition, next return value, ...)
Or use a lookup function:
HansVogelaar Thank you for your help. This worked for me, with the exception of the last condition that I needed to be greater than 3000. When I tried C12>3000, 1.3, it would give me a N/A error. To eliminate the error, I had to change the 3000 to 1. Then my calculation worked. Can you help me with an explanation?
It should work:
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
