IF function

[bobb111]

Hi
I am a noob when it comes to the IF formula and all things Excel; I need help with the blank cell that has -45378. How would I make this so it is blank i can't put this in a mini sheet as its a work computer and will not let me put it on the computer

 

[MARK858]

Adjust the cell references to suit as you haven't told us what cells your data is in

Forum 27.3.xlsm
	D	E	F	G
2				27/03/2024
3
4
5	25/03/2024	-2
6	28/03/2024	1
7	15/04/2025	384
8
9
10
11
Sheet2

Cell Formulas
Range	Formula
E5:E11	E5	=IF(D5<>"",D5-$G$2,"")

 

[Peter_SSs]

Looks like a formal excel table so try the following with G$2 in my formula being the cell at the top of your image with 27/03/2024 in it

=IF([@DATE],[@DATE]-G$2,"")

 

[bobb111]

Thank you for the help this worked

 

[MARK858]

Happy we could help and welcome to the forum