excel multiple logical test?

I can't get the code to work. I need it to times E59 by five when these months are shown

=+D29/IF(AND(E59="*January",E59="*April",E59="*July",E59="*October"),5,4)

Update:

=+D29/IF(OR(E59="*January",E59="* April",E59="*July",E59= "*October"),4,5)

Please enter comments
Please enter your name.
Please enter the correct email address.
You must agree before submitting.

Answers & Comments


Helpful Social

Copyright © 2024 Q2A.ES - All rights reserved.