Need help with an IF AND function formula

[JenMcG]

Hello,

I need help making a formula that will perform a calculation based on the following criteria:

Cell L8 must contain the work "Emergency"
and
Cell CV must be less than or equal to 3

If this criteria is met I need to perform the following calculation:

Value of CH880.30%

Otherwise blank

I tried this and it did not work:
=IF(L8="Emergency"&CV8<=3,CH8*0.30%,"")


Please help.

Thanks,
Jen

 

[Joe4]

You can have up to 30 conditions in your AND statement (see: https://www.techonthenet.com/excel/formulas/and.php).
So your current formula has two, separated by a comma. So just add another comma and add the third.
That is pretty straightforward, so I will leave that to you. It will be a good test to make sure you understand how the AND function actually works.

 

[JenMcG]

Easy!

Thanks,
Jen