I have been tryiing to get this to work for the last few hours, and need some assistance. i believe it is an IF AND statement, but as I have tried, I keep getting false when changes are made
=IF(AND($AK9>0,$K9<>"Van",($AN$3*$AK9)),($AK9*$AR$3))
i am also trying to expand on this to say if AK=0 or is blank, then multiply AL by either AN3 or AR3 depending on what is in column K (multiple text)
Please help
=IF(AND($AK9>0,$K9<>"Van",($AN$3*$AK9)),($AK9*$AR$3))
i am also trying to expand on this to say if AK=0 or is blank, then multiply AL by either AN3 or AR3 depending on what is in column K (multiple text)
Please help