I am trying to nest two IF formulas: =IF(D4>0,D4*.3,IF(F4>5,(F4-5)*45),0). Or, stated in English, If D4 is more than 0, then D4 times 0.3, if not, then if F4 is more than 5, then(F4 minus 5) times 45, if not then 0.
Also, I have subscribed to Office 365 and a Google search told me that I should be able to nest IF Statements using the function IFS, but I don't have that function.
Solved by B. W. in 19 mins