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)
Copyright © 2024 Q2A.ES - All rights reserved.
Answers & Comments
Verified answer
You might add the formula again with spaces to break it up in order to defeat the Yahoo filter
BUT... from what is shown, you need to *OR*, not AND, the months. There's no way a cell can contain two values at the same time, as is implied by
AND(E59="*January",E59="*April" . . .
Try
OR(E59="*January",E59="*April" . . .
Instead
There are a pair of diverse procedures to do it, although the finest (no matter if it really is purely some logical checks) is to embed/nest yet another IF fact into the unique IF fact. remember that in Excel --> =IF(logical try, cost if genuine, cost if faux) you are able to position yet another IF fact into both the 'cost if genuine' and/or the 'cost if faux' sections of the parameter. look into the source article for an party.