help with IF statement

[MAYO]

I want something that
IF cell A1 = blank AND B1 = blank then C1 would = 1 OR ELSE C1 = BLANK




what would the formula be for something like that?

 

[Arovin]

Try writing this formula in C1:

=IF(AND(ISBLANK(A1);ISBLANK(B1));1;"")

 

[MAYO]

It says it contains an error but thanks for the shot at it...

 

[drgracer]

Replace the semicolons with commas.

=IF(AND(ISBLANK(A1),ISBLANK(B1)),1,"")

Excel uses ;'s as delimiters in some countries and ,'s in others

 

[MAYO]

Omg thanks so much it works but 1 problem when a or b have value i want c to go blank but it only goes blank when both have values how can i make it where if either a or b have values the c goes blank?

 

[MAYO]

Disregard last message i made a mistake..lol

It works 100% exactly how I wanted thanks so much.