# "If" & "And" formula question

#### Jamm_027

##### Board Regular
This is in my ind what the formula should look like but it doesn't work. How do a write it?

If ((B488=False)and(if(B487=False),C486,C488)

thanks,

jamm

### Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

#### BAlGaInTl

##### Well-known Member
This is in my ind what the formula should look like but it doesn't work. How do a write it?

If ((B488=False)and(if(B487=False),C486,C488)

thanks,

jamm

What do you mean by false? The actual word "False," or is it a formula that returns False?

Try this...

=IF(AND(B488="False",B487="False"),C486,C488)

#### mooseman

##### Board Regular
if ((b488=false)and(if(b487=false),c486,c488)

if(and(b488=false,b487=false),c486,c488)

#### stanleydgromjr

##### Banned
Jamm_027,

Try:
=IF(AND(B488=FALSE,B487=FALSE),C486,C488)

or

=IF(AND(B488="FALSE",B487="FALSE"),C486,C488)

Have a great day,
Stan

#### Jamm_027

##### Board Regular
Got it.....thanks everyone!

#### Scott Huish

##### MrExcel MVP
I think you could also do it by checking for the existence of TRUE:

=IF(OR(B487:B488),C488,C486)

Replies
2
Views
201
Replies
1
Views
141
Replies
1
Views
212
Replies
3
Views
305
Replies
6
Views
188

1,191,043
Messages
5,984,308
Members
439,882
Latest member
gerdc

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back