tazmtiger777
New Member
- Joined
- Feb 18, 2021
- Messages
- 4
- Office Version
- 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.
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.