Formula help

[MissK2018]

Hi Again,

I have another formula giving me trouble ... (LOL)

=IF(B13="FT",(F18/37.5*C20),IF(B13="contract",(F18/37.5*C20),IF(B13="PT",52.5)))


The formula works as is BUT I want it to do this instead:
If B13=FT (F18/37.5*20)
if B13 = PT enter 52.5
If B13 = Contract AND D13 = PT then enter "6%"
if B13 = Contract AND D13 = FT then (F18/37.5*C20)

I've got this formula - but I'm getting a "false" response:
=IF(B13="FT",(F18/37.5*C20),IF(AND(B13="contract",D13="FT")*(F18/37.5*C20),IF(AND(B13="contract",D13="PT")*"6%",IF(B13="PT",52.5))))


Thanks in advance !!

 

[Nine Zero]

Hello i believe this is what you were needing

=IF(B13="FT",(F18/37.5*C20),IF(AND(B13="contract",D13="FT"),(F18/37.5*C20),IF(AND(B13="contract",D13="PT"),"6%",IF(B13="PT",52.5,0))))

you were close but had some multiplication where a comma was needed ... this was yours and in red is what i changed

=IF(B13="FT",(F18/37.5*C20),IF(AND(B13="contract",D13="FT")*(F18/37.5*C20),IF(AND(B13="contract",D13="PT")*"6%",IF(B13="PT",52.5,0))))

the zero on the end is just an exit statement if nothing is true ... feel free to insert whatever

 

[MissK2018]

Thank you!!

I'm stumped .. again ! LOL