Thread: IF AND function
View Single Post
  #1   Report Post  
Chink!
 
Posts: n/a
Default IF AND function

Hello

I'm trying to write a formula for the following:

If the value in cell B8 < 621
AND
if the value in cell B21 < 3000

value = YES

if not value = NO

Ive tried various ways to write it but keep getting an error

Can someone please let me know the formula?

many thanks
CH!