IF formula or alternative

[PurrSent]

I have a spreadsheet in which the total of the values entered along the row are displayed in column 'E'

Gift Aid is marked 'Y' or 'N' in column 'F', with the amount entered into column 'G' if 'Y' or 'F' if 'N', ie depending on whether the person can Gift Aid, or not.

If possible, I would like the value in 'E' to be displayed in the relevant cell with regard to their Gift Aid status, ie 'G' or 'F'

I've made an attempt at this but I'm stabbing in the dark, really.

My train of thought is: =IF ... F3="Y", then display 'Gross' value in 'G3', otherwise display value in 'F'

Maybe someone can help me out here, please? I'd be very grateful.

Here is a 'mock' section of the spreadsheet, to help with my explanation (below)

Many thanks for any help.

 

[Marcelo Branco]

Re: Help with 'IF' forumla, or alternative, needed, pls

Try

G3
=IF(F3="Y",E3,"")

H3
=IF(F3="N",E3,"")

M.

 

[PurrSent]

Re: Help with 'IF' forumla, or alternative, needed, pls

Marcelo Branco

Thank you very much.
This works well
I very much appreciate your help
J

 

[Marcelo Branco]

Re: Help with 'IF' forumla, or alternative, needed, pls

You are welcome. Glad to help.

M.

 

[PurrSent]

Re: Help with 'IF' forumla, or alternative, needed, pls

You certainly have helped, Marcelo
Much appreciated
J