Need help with IF statement.

djl0525

djl0525

Well-known Member
Joined
Dec 11, 2004
Messages
1,238
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.
Sort by date Sort by votes
Oaktree

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,115
Office Version
  1. 365
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...
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question
Help with formula calculating target miles per day
Replies
1
Views
67
James006
James006
W
  • Solved
Looking for IF statement for greater than and less than
Replies
4
Views
341
WindsorExcel
W
S
  • Question
SUMIFS returning 0?
Replies
3
Views
129
Fluff
Fluff
S
  • Question
SUMIF but with Calculation First
Replies
6
Views
206
Sufiyan97
Sufiyan97
N
  • Solved
Find Average of Mileage Bands
Replies
4
Views
63
awoohaw
awoohaw

Forum statistics

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

Share this page

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top