Can Any one here help me with IF(Blank question

tazmtiger777

New Member
Joined
Feb 18, 2021
Messages
4
Office Version
  1. 365
Hi
I have this formula to calculate minutes in the J column for each row with values, and it starting with J10.

Example:
"=IF(I10>H10,I10-H10,I10+1-H10)" It returns the difference between two values in Cell I10 and H10 to Cell J10 (all good there!)

My question is:
How can I tell the example formula above to ignore placing any values in the J10 if any of the corresponding values in the H10 to I10 are left blank.

In other words, if there in no value in any calculation "called by a corresponding cells in "J column" ……. How do I tell it to display no value, or leave the target cell blank?
Rather than placing the default value of my calculation "which is 1440." That gets rather messy since I have many rows that may be skipped in between with no value, or rows that have no input at all. And since my formula returns a default value of 1440, it adds that to may totals for each blank line left without inputs.

I just need each corresponding cell to return a value as indicated in row by the cell in column J, --->Only if corresponding cells in "H or I columns" have a typed-in value in them and are not left blank?

But want the corresponding cell to stay blank IN COLUMN J "if any cell it calls values for "has been left blank, or has no value in it."

(Example: On Cell J10 I have "=IF(I10>H10,I10-H10,I10+1-H10)" <-- It asks to return the difference between two cells that contain time values in them and it returns the difference between the two time values to J10) But when J10 asked values are left blank, it automatically returns 1440 in the J10 cell.

Hope I make sense.

Thank you in advance to anyone that can provide me any assistance with my question.
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

JamesCanale

Board Regular
Joined
Jan 13, 2021
Messages
158
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
wrap your formula with:
=if(or(i10="",h10=""),"",YOURFORMULA)
 

Watch MrExcel Video

Forum statistics

Threads
1,129,352
Messages
5,635,785
Members
416,882
Latest member
ericvrealty

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