"=IF" Question

[steve400243]

Hello Forum. Question for you experts, I use the below cell formula to calculate a rate based on "FMM" text in column D as shown. I need to have "IDPO" added in to calculate "0" if this is the text in that cell? The below is not working.

=IF(F29<0.01,0,ROUND(IF(D29="FMM",F29*16.5,MAX(F29*13,65)),2*[FONT=arial]IF(D29="IDPO",0)))[/FONT]

Thanks for any help provided.

 

[offthelip]

IO am not quite sure what you are trying to do but this shows you how to combine the two test for zero

=IF(OR(D29="IDPO",F29<0.01),0,ROUND(IF(D29="FMM",F29*16.5,MAX(F29*13,65)),2))

 

[steve400243]

IO am not quite sure what you are trying to do but this shows you how to combine the two test for zero

=IF(OR(D29="IDPO",F29<0.01),0,ROUND(IF(D29="FMM",F29*16.5,MAX(F29*13,65)),2))

This worked, thank you for your time offthelip!