IF function not working

[defender]

Hi,

Not sure why i can't get this basic IF function to work.

if the value in cell G3 = 0 then i want to return the word 'Expired' else leave the call blank.

This is what i tried but it didn't work

=IF(G3="0", "Expired", "")

 

[joeu2004]

Do not put quotes around values that you intend to be treated as numeric. If G3 is empty or it contains the numeric value zero, the formula should be:

=IF(G3 = 0, "Expired", "")

 

[Aladin Akyurek]

You might want to also include an additional test...

=IF(ISNUMBER(G3),IF(G3=0, "Expired", ""),"")​

 

[snjpverma]

when does your formula not work?

See if this works.

=IF(G3,"","Expired")

 

[defender]

thanks guys its working now.

I got one more thing which i'm not able to sort. i'm using the formula F3-TODAY()....where F3 is a date in the future. This works on for the first cell i entered this formula in, but if i want to drag down the formula i get -43141 in the all the other cells, but i want them to remain blank until a value is added in F4, F5, F6.....etc

 

[jtakw]

Hi,

Book1
	F	G
3	2/11/2018	1
4
Sheet61

Cell Formulas
Range	Formula
G3	=IF(F3<>"",F3-TODAY(),"")
G4	=IF(F4<>"",F4-TODAY(),"")

 

[defender]

awesome, thank you.

 

[jtakw]

You're welcome.