Need help with IF statement.

djl0525

djl0525

Well-known Member
Joined
Dec 11, 2004
Messages
1,240
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

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Sort by date Sort by votes
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

himderfella
  • Solved
Do not calculate formula if there are blank cells
Replies
4
Views
508
MARK858
MARK858
E
  • Question
Help Cleaning Up / Optimizing VBA Code
Replies
6
Views
270
offthelip
O
W
  • Solved
Multiple MsgBox based on the same column but different keywords in the column
Replies
3
Views
133
kevin9999
K
H
  • Solved
Formula Help - Time it takes to run 100 miles and then convert it to time of day
Replies
7
Views
310
Hankmardukaas
H
R
  • Question
Help with formula calculating target miles per day
Replies
1
Views
116
James006
James006

Forum statistics

Threads
1,214,653
Messages
6,120,749
Members
448,989
Latest member
mariah3

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
Back
Top