| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested IF function (simple)
Hi,
Am Fri, 29 Jun 2018 17:33:29 +0100 schrieb TeKouma: You cannot put e2+if. you didn't test it! Regards Claus B. -- Windows10 Office 2016 |
|
#2
|
|||
|
|||
|
Quote:
Yah, you can't do that. Here's what it looks like with that https://i.imgur.com/oSD6WfS.png Your suggestion seems logical as well though. Last edited by TeKouma : June 29th 18 at 07:19 PM |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Nested IF function (simple)
Hi,
Am Fri, 29 Jun 2018 19:05:25 +0100 schrieb TeKouma: Yah, you can't do that. Here's what it looks like with that https://i.imgur.com/oSD6WfS.png Your suggestion seems logical as well though. my formula is tested and it is working. If it doesn't work in your workbook, your values are text. It seems that they have leading oder trailing spaces. If you can't get it to work, send your workbook to claus_busch(at)t-online.de Regards Claus B. -- Windows10 Office 2016 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple nested if and statement | Excel Worksheet Functions | |||
| Simple question?? Nested ifs on one line | Excel Programming | |||
| Simple nested if statement | Excel Discussion (Misc queries) | |||
| simple nested loop question | Excel Programming | |||
| Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Hybrid Mode
