How do I create this conditional formula
Closed
Dlene03
-
9 Oct 2017 à 16:19
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 10 Oct 2017 à 11:31
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 10 Oct 2017 à 11:31
Related:
- How do I create this conditional formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Create blackberry id - Guide
- How to create viber group - Guide
- Create skype account - Guide
- Create gmail - Guide
2 responses
You can nest IF OR & AND. take a look at the example, and have fun!
=IF(AND(A3>B2,A3<C2),TRUE,FALSE)
You can read more here:
https://support.microsoft.com/en-us/office/using-if-with-and-or-and-not-functions-d895f58c-b36c-419e-b1f2-5c193a236d97?ui=en-us&rs=en-us&ad=us
Once again, have fun!
=IF(AND(A3>B2,A3<C2),TRUE,FALSE)
You can read more here:
https://support.microsoft.com/en-us/office/using-if-with-and-or-and-not-functions-d895f58c-b36c-419e-b1f2-5c193a236d97?ui=en-us&rs=en-us&ad=us
Once again, have fun!
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
10 Oct 2017 à 11:31
10 Oct 2017 à 11:31
Hi Dlene,
Give the following formula a try:
=IF(IF(A2="H",1,IF(A2="HP",3,0))+IF(B2="H",1,IF(B2="HP",3,0))+IF(C2="H",1,IF(C2="HP",3,0))=5,98,"")
Best regards,
Trowa
Give the following formula a try:
=IF(IF(A2="H",1,IF(A2="HP",3,0))+IF(B2="H",1,IF(B2="HP",3,0))+IF(C2="H",1,IF(C2="HP",3,0))=5,98,"")
Best regards,
Trowa
