Leaving cell blank ?

[JMITCH26]

=IF(AND(ISTEXT(F4),ISNUMBER(E4)),E4-60,E4)

The cell leaves a 0 with this current formula the math is fine but I would like the cell to be blank instead of 0. I have tried a few different ways but it keeps showing error.

any help on this would be great.

 

[dreid1011]

Usually a blank would be in the FALSE result where you have E4. What is the value of E4 when the formula returns 0? And are you wanting it to return blank when the conditions are FALSE?

=IF(AND(ISTEXT(F4),ISNUMBER(E4)),E4-60,"")

 

[JMITCH26]

Nothing is in E4 when it returns 0

its a mileage chart

​	A​	B​	C​	D​	E​	F​	G​	H​	I​
1​	​	​	​	​	​	​	​	​	​
2​	​	Miles​	Distance​	Start/End​	MQ​	-60​	Total​	Date​	Day​
3​	1​	271215​	​	Start​	​	​	0​	Jun 3, 2024​	Monday​
4​	2​	271277​	62​	End​	62​	X​	2​	Jun 3, 2024​	Monday​
5​	3​	271277​	​	Start​	​	​	0​	Jun 3, 2024​	Monday​
6​	4​	271301​	24​	End​	24​	​	24​	Jun 3, 2024​	Monday​

Formula is in column G4,
Im asking G4 to look for the letter X in F4
IF there is a letter in F4 then deduct 60 miles from E4 and report the total in G4

it looks like that is working ok
but when I have nothing entered into lets say E5 it returns a 0 I would rather have it be blank
when trying to use a few blank formula so it leaves nothing in the cell I get an error

Thanks for the help on this
I'm sure its some small step I'm leaving out

or maybe there is a better way to wright the whole line

 

[dreid1011]

Did you try the modification I suggested to your current formula? You can try it this way too, but it's essentially the same formula:

=IF(AND(F4="X",E4<>""),E4-60,"")

 

[JMITCH26]

=IF(AND(ISTEXT(F4),ISNUMBER(E4)),E4-60,"")

the first one you sent works perfectly sorry I had a typo in it when I first typed it back in

but it works fine now thank you for the help

 

[JMITCH26]

OK, there is one more thing I noticed when you have the mileage in E6 and you add the X in F6 it will do that math and deduct the the 60 miles and report to G6 perfectly

but when you have the mileage E6 and there is no X in F6, G6 will remain blank instead of showing the mileage from E6

again thanks for the help on this.

 

[dreid1011]

Alright, so try this:

=IF(AND(ISTEXT(F4),ISNUMBER(E4)),E4-60,IF(E4<>"",E4,""))

 

[JMITCH26]

Now that works perfectly thank you for looking into this.

 

[dreid1011]

You're welcome, and happy to help.