IF function
 

Hi - I have a spreadsheet which I record all my monthly outgoings in.

I put a tick in column E against each amount when it's come out of my
account. Can anyone tell me if there is a way of getting column F to read £0
when I've put the tick in column E?

I know it's something along the lines of 'if E5 has an a in it, F5 = 0' but
also want F5 to show the amount in C5 if there is no a in E5.

Hope this makes sense and someone can help!

IF function
 

Hi,

The problem is the tick because I have no idea how you put it there and
there are several ways. So this formula in F5 will do what you want if you
substitute the word tick for whatever character you are using.

=IF(E5="tick",0,C5)

Mike

"whaler" wrote:

Hi - I have a spreadsheet which I record all my monthly outgoings in.

I put a tick in column E against each amount when it's come out of my
account. Can anyone tell me if there is a way of getting column F to read £0
when I've put the tick in column E?

I know it's something along the lines of 'if E5 has an a in it, F5 = 0' but
also want F5 to show the amount in C5 if there is no a in E5.

Hope this makes sense and someone can help!

IF function
 

Thank you so much for your really quick response!

I put an 'a' in in webdings to get the tick - don't know if there's a better
way!! The formula works though - thanks again!



"Mike H" wrote:

Hi,

The problem is the tick because I have no idea how you put it there and
there are several ways. So this formula in F5 will do what you want if you
substitute the word tick for whatever character you are using.

=IF(E5="tick",0,C5)

Mike

"whaler" wrote:

Hi - I have a spreadsheet which I record all my monthly outgoings in.

I put a tick in column E against each amount when it's come out of my
account. Can anyone tell me if there is a way of getting column F to read £0
when I've put the tick in column E?

I know it's something along the lines of 'if E5 has an a in it, F5 = 0' but
also want F5 to show the amount in C5 if there is no a in E5.

Hope this makes sense and someone can help!

IF function
 

Thanks for the feedback. Other ticks, probably not exhaustive:-

Marlett a
Monotype sorts 4
Wingdings2 P or R

Mike

"whaler" wrote:

Thank you so much for your really quick response!

I put an 'a' in in webdings to get the tick - don't know if there's a better
way!! The formula works though - thanks again!



"Mike H" wrote:

Hi,

The problem is the tick because I have no idea how you put it there and
there are several ways. So this formula in F5 will do what you want if you
substitute the word tick for whatever character you are using.

=IF(E5="tick",0,C5)

Mike

"whaler" wrote:

Hi - I have a spreadsheet which I record all my monthly outgoings in.

I put a tick in column E against each amount when it's come out of my
account. Can anyone tell me if there is a way of getting column F to read £0
when I've put the tick in column E?

I know it's something along the lines of 'if E5 has an a in it, F5 = 0' but
also want F5 to show the amount in C5 if there is no a in E5.

Hope this makes sense and someone can help!