# Need help with IF statement.

#### djl0525

##### Well-known Member
C21: Gas expense
D21: Miles traveled

What is the formula to find the cost per gallon, if C21 and D21 are not blank, please?

Thanks -- DJ

### Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

#### Oaktree

##### MrExcel MVP
Cost per gallon? Or cost per mile?

Cost per mile would be =IF(AND(C21<>0,D21<>0),C21/D21,"")

Cost per gallon would be C21/(D21/MPG) instead of C21/D21, but you'd need to know MPG...

Thanks!

Replies
1
Views
67
Replies
4
Views
341
Replies
3
Views
129
Replies
6
Views
206
Replies
4
Views
63

1,195,619
Messages
6,010,735
Members
441,567
Latest member
Flitbee

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