| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Linear Mode
