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
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