Mar 01 2019 05:16 AM
Can anyone help me with a formula - here is my formula I am looking for..... If G41 is >90 but <120 then H37 = 2
I appreciate any assistance :)
Mar 01 2019 06:35 AM
SolutionHi,
You need to use IF function along with AND as follows:
=IF(AND(G41>90,G41<120),2,0)
Hope that helps
Mar 01 2019 08:19 AM
Thank you Sir, That did it!!!
Any chance you could help with another that is similar?
here is the formula I am looking for:
IF G41 IS >90 BUT <120 = $200 OR IF G41 IS >121 BUT <180 = $300 OR IF G41 IS >181 = $500
I so appreciate your help!
Mar 01 2019 08:58 AM - edited Mar 01 2019 08:59 AM
Hi,
Here's the formula:
=IF(AND(G41>=90,G41<=120),200,IF(AND(G41>=121,G41<=180),300,IF(G41>=181,500,0)))
Here's another one (Works in Excel 2019 and Office 365).
=IFS(AND(G41>=90,G41<=120),200,AND(G41>=121,G41<=180),300,G41>=181,500,TRUE,0)
Hope that helps
Mar 01 2019 09:17 AM
Mar 01 2019 11:10 AM
Mar 01 2019 06:35 AM
SolutionHi,
You need to use IF function along with AND as follows:
=IF(AND(G41>90,G41<120),2,0)
Hope that helps