If cell value not selected - should not display false

[Beena K]

Please help !!!
In One selection - I have given a drop down using validation (list)
If user selects from this drop down - then another cell reflects a number as
per the selection criteria.
For e.g. D9 = Largely \ Fully \ Partially \ NA as a drop down
If user selects any one Largely \ Fully \ Partially \ NA , then the Cell in
col E9 will show a value.
However if no selection is made in D9, then E9 shows FALSE.
How do I handle this - E9 Shows false.

Thanks in adavnce
Beena K

 

[Max]

Something like this ..
In E9: =IF(D9="","",D9)
where D9 houses the DV

 

[Beena K]

HI Max
I tried your suggestion, but it is not working.

Given below the query in more details once more, hope you can help me out

Column D :- As per Validation list --- (Implemented, Not Implemented, NA)

Column E :- Formula applied is =IF(D12="Implemented",3,(IF(D12="Not
Implemented",2,(IF(D12="NA","")))))

Like I said – if the user does not make a selection, then Col E Cell shows
entry as False.

Please, can you help

Cordially,
Beena K

 

[Max]

This should suffice, try in E12:
=IF(D12="","",IF(D12="Implemented",3,IF(D12="Not
Implemented",2,IF(D12="NA",""))))

The check on D12's DV for "nothing" selected by user can be done in front,
viz., this part: IF(D12="","",...

 

[Beena K]

Hi Max

Thanks a million
It worked.

Cordially
Beena K

 

[Max]

Welcome, and thanks for feeding back

In future, think it's better/appropriate that you post questions on
functions in:

microsoft.public.excel.worksheet.functions

(It's a much more active group, and you'd likely receive responses faster)