CAN IT BE DONE

[adierobo]

Hi all newbie to this site this may be a questionable action however if I enter a figure into F22 and another into F23 I need a total in F24 but then the total divided by 3 in F25
this is the point that may not be possible I only need this formula to appear when I enter total into D25. I know that =$C$4="SERVICE" will allow cells to blank when service is not entered I just don't know if making a formula disappear until you enter a word is possible Any thanks for looking Adrian

 

[Eric W]

Welcome to the forum!

See if this works for you:

Book2
	D	E	F
22			77
23			88
24			165
25	Total		55
Sheet8

Cell Formulas
Range	Formula
F24	F24	=SUM(F22:F23)
F25	F25	=IF(D25="Total",F24/3,"")

 

[adierobo]

many thanks back in work Friday ill give it a go