# IF formula problem

#### G Marshall

##### Board Regular
Hi There

I have the following formula =IF(BQ64,SUM(BO64+BQ64),BO64)

If there is a number in cell BQ64 then I want Cell BP64 to return the sum of cells BO64 & BQ64. If there is no number in cell BQ64 then I want Cell BP64 to return only the value in Cell BO64.

Seems simple enough and works ok except when there is no number in cell BQ64 then Cell BP64 is showing #value

Is my formula wrong?
I would appreciate someones help.

Thanks

Gerald

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Try:

=IF(BQ64,SUM(BO64,BQ64),BO64)

You need a True/false test and do not need sum. try this instead

=IF(ISNUMBER(BQ64),BO64+BQ64,BO64)

Try

=BO64+N(BQ64)

Hi there

Thanks a million to you both, worked perfectly. What a super forum.

Gerald

Probably even simpler to use just

=SUM(B064:BQ64)

=IF(ISNUMBER(BQ64)=TRUE,SUM(BO64+BQ64),IF(ISNUMBER(BQ64)=FALSE,BO64,""))

????

Is this Good for you?

Replies
11
Views
192
Replies
4
Views
94
Replies
4
Views
66
Replies
4
Views
82
Replies
2
Views
103

1,214,262
Messages
6,118,549
Members
448,835
Latest member
Profast123

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