Need IF formula amending as "Too many arguments"

[Ironman]

Hi

I have this formula

IF(ROUND(F5,2)=ROUND('Daily Tracking'!CG375,2),"MILES RUN THIS/LAST YTD  ►","ERROR! YTD MLG <> F5")

that I want to substitute the actual current/previous year i.e. "& THIS YEAR() & "/" & THIS YEAR()-1" (without the outer commas) for "THIS/LAST" but Excel errors "Too many arguments" and I don't know how to fix it. I seem to think I need the IFS function but I've tried it without success.

Help appreciated.

Many thanks!

 

[Michael M]

Where do you want it in the existing formula
Try using =YEAR(TODAY()) &"/" & YEAR(TODAY()-365)
AND
I think your original formula needs to be

=IF(ROUND(F5,2)=ROUND('Daily Tracking'!CG375,2),"MILES RUN THIS/LAST YTD  ►","ERROR! YTD MLG <>" &  F5)

 

[Ironman]

Hi Michael - yes, I take your point thanks and that is intentional as the cell is filled red when it errors and it's easy for me to see the correct value in F5.

I'm guessing this, but again, it's incorrect:

=IF(ROUND(F5,2)=ROUND('Daily Tracking'!CG375,2),"MILES RUN"& YEAR(TODAY()) & "/" & YEAR(TODAY()-365) "YTD  ►","ERROR! YTD MLG <> F5")

 

[Ironman]

Ahh, I've sorted it - many thanks Michael.

=IF(ROUND(F5,2)=ROUND('Daily Tracking'!CG375,2),"MILES RUN "&YEAR(TODAY())&"/"&YEAR(TODAY()-365)&" YTD  ►","ERROR! YTD MLG <> F5")

 

[Michael M]

Glad it worked for you...